You can tune the performance of SQL queries by using the SQL Query Optimization Messages to determine:
There are two main types of Optimization messages:
Join order and method, sort required, total estimated cost.
Detail estimates for each join order/method combination.
Rows read from index and data, rows qualified, rows sorted, and so on, during the time the plan was open.
Same data as summary, but for each execution of a statement.
|
Copyright © 2014 CA.
All rights reserved.
|
|