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.