|The execution plan in Query Analyzer|
Cachè Monitor provides a visual display of an execution plan for SQL Queries. With this information it is more easily to tune SQL Statements.
Whenever an SQL Statement is executed, InterSystems Caché designs an execution plan for it. This execution plan is basically a step for step instruction for how the statement must be executed. That is, the order in which tables/globals are read, if indexes are used, which join methods are used to join tables and so on.
The execution plan for an sql statement can be viewed through selecting the Execution Plan - Tab. If you select this tab, the execution plan will be calculated and displayed. Consider please that only ONE SQL Statement is in editor area!! This limitation will be fixed soon.
If you select an index node in the execution plan (Querytree), you see information about existing indexes on the used tables. Additionally the calculated and current used selectivity is available.