By adding the expression noted above to the end of an SQL statement, CONNX will return the query execution plan instead of the requested data.
Example:
SELECT * FROM customers, orders WHERE customers.name = "Meyer" and customers {statistics}
{statistics} SQL Extended Function
|
Step |
Table |
Action |
|---|---|---|
|
1 |
Customers |
CONNX performs a keyed lookup using index #2. |
|
2 |
Orders |
CONNX performs a crosstable lookup using data retrieved from table "Customers" and using index #40. |