The execution plan in Query Analyzer PDF Print E-mail

Cachè Monitor provides a visual display of an execution plan for SQL Queries. With this information it is more easily to tune SQL Statements.

An SQL statement expresses what you want but does not tell Caché how to do it. It will decide the best way to compute the results. InterSystems Caché chooses whether it is better to read completely the table/globals, or whether using an index would be faster. It compares the cost of all possible approaches. The way that a statement can be physically executed is called an execution plan or a query plan. With Caché Monitor`s Query Analyzer you can view this execution plan in a tree like view.

sql query

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.