Determining which queries are impacted during migration

This section describes how to determine which queries are impacted during migration for Adaptive Server versions 12.5 and later to version 15.0

There are many ways you can identify queries impacted by changes in the query processing engine during migration. Each of the sections below describes a different scenario and a resolution.

You can automate this process with the Migration Analyzer in DBExpert 15.0, which compares the query plans and execution statistics between queries in Adaptive Server 12.5 and 15.0, identifying which queries have been changed and what the impact was.