Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - SQL Usage » Query optimization and execution » Reading execution plans » Reading graphical plans


Analyzing performance using the graphical plan with statistics

You can use the graphical plan with statistics to identify database performance issues. For detailed field descriptions of the graphical plan with statistics, see Node Statistics field descriptions, and Optimizer Statistics field descriptions.

 Identifying query execution issues
 Reviewing selectivity performance
 Reviewing cache performance
 Identifying ineffective indexes
 Identifying data fragmentation problems