Understanding QTA fundamentals

While guiding us through the recommended process, QTA doesn't follow it exactly. The very last step 5 will not have the same outcome as we saw in the previous section: instead of providing options to revert to a last known good plan, QTA helps to find a new state that is not the pre-CE upgrade or post-CE upgrade plan, but a new plan that will hopefully outperform both of the previous plans.

The following diagram summarizes the recommended steps to minimize risk with CE upgrades using QTA, which replaces the very last step of the process described in the Understanding where QTA is needed section:

How does QTA ...

Get Learn T-SQL Querying now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.