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.
See also:
Explain
Plan
EXPLAIN
Example
> set autoexplain on
> select company, contact from customers where company='systems'
----------------------------------- SUMMARY -----------------------------------
Select COMPANY, \
CONTACT \
from CUSTOMERS \
where COMPANY = 'systems'
Version: 4.0 Build 8G (Compiled Jan 30 2004 12:50:07)
Optimization: MDKQUAL
----------------------------------- DETAILS -----------------------------------
Qualify (CUSTOMERS)CUSTOMERS where COMPANY = 'systems' on 1 with NOAUTORESET
Fetchkeys $ROWID 1000 at a time on 1
Retrieve CUSTOMERS using $ROWID = $ODXID
Return CUSTOMERS.COMPANY, CUSTOMERS.CONTACT
-------------------------------------------------------------------------------
Top
|
