SET Options

AUTOEXPLAIN

SET AUTOEXPLAIN <ON | OFF>

AUTOEXPLAIN is available for use in ODXSQL ONLY.

The AUTOEXPLAIN set option causes an Explain Plan to be generated and displayed for each SQL SELECT statement passed through OdxSQL. AUTOEXPLAIN causes the EXPLAINONLY option to be applied to the SELECT statement. No data will actually be retrieved.

This is particularly useful when obtaining optimization information on multiple select statements contained within an OdxSql USE file.

This setting only applies to SQL SELECT statements. Data updates, qualifies, and other statements will perform as normal.

Example

Connected to C:\omnidex\Demodata\orders.env
> set autoexplain on
> select company from customers where state='co'

---------------------- SUMMARY
Select COMPANY \
from CUSTOMERS \
where STATE = 'co' \
with EXPLAINONLY

Version: 3.7 Build 10C (Compiled Oct 25 2001 10:20:01)
Num rows: Unknown
Cursor Opt: MDKQUAL, AGGREGATION, ASKQUAL, ASKORDERBY, ASKLINK,
NO_ASKRETRIEVAL, STARSCHEMA
Request Opt: MDKQUAL, AGGREGATION, ASKQUAL, ASKORDERBY, ASKLINK,
NO_ASKRETRIEVAL, STARSCHEMA
Required Opt: NONE
Actual Opt: MDKQUAL
Warnings: NONE
------------------- QUALIFICATION -------------------
Qualify (CUSTOMERS)CUSTOMERS where STATE = 'co' on 1 with NOAUTORESET
--------------------- RETRIEVAL ---------------------
Fetchkeys $RECNO 1000 at a time on 1
Retrieve CUSTOMERS using $ROWID = $ODXID
Return CUSTOMERS.COMPANY
-----------------------------------------------------

>

top