EXPLAIN
SET EXPLAIN <[NO]COUNTS|[NO]SUMMARY|[NO]DETAILS|[NO]ADDIN>
ODXSQL ONLY.
EXPLAIN defines what information will be displayed in an Explain Plan.
Toggle each setting with or without the NO prefix.
The default setting is: NOCOUNTS, SUMMARY, DETAILS,
ADDIN
COUNTS - display qualifying counts
SUMMARY - display the SUMMARY section of the Explain Plan
DETAILS - display the DETAILS section of the Explain Plan
ADDIN - display the ADDIN section of the Explain Plan
Example
> set defaults
All settings are returned to their defaults
> select company, contact from customers where company='%systems or
software'
...
>explain
----------------------------------- SUMMARY -----------------------------------
Select COMPANY, \
CONTACT \
from CUSTOMERS \
where COMPANY = '%systems or software'
Version: 3.8 Build 5G (Compiled Sep 8 2003 09:23:53)
Request Opt: PRIKEY, MDKQUAL, NO_DISTINCT_MDK_KEYWD, ASKQUAL, ASKORDERBY,
AGGREGATION, ASKLINK, NO_ASKRETRIEVAL, STARSCHEMA
Required Opt: NONE
Actual Opt: MDKQUAL
Warnings: NONE
----------------------------------- DETAILS -----------------------------------
Qualify (CUSTOMERS)CUSTOMERS where COMPANY = 'systems or software' on
1 with \
NOAUTORESET
Fetchkeys $RECNO 1000 at a time on 1
Retrieve CUSTOMERS using $ROWID = $ODXID
Return CUSTOMERS.COMPANY, CUSTOMERS.CONTACT
-------------------------------------------------------------------------------
>
> set explain nosummary
> explain
----------------------------------- DETAILS -----------------------------------
Qualify (CUSTOMERS)CUSTOMERS where COMPANY = 'systems or software' on
1 with \
NOAUTORESET
Fetchkeys $RECNO 1000 at a time on 1
Retrieve CUSTOMERS using $ROWID = $ODXID
Return CUSTOMERS.COMPANY, CUSTOMERS.CONTACT
-------------------------------------------------------------------------------
>
> set explain summary, counts
> explain
----------------------------------- SUMMARY -----------------------------------
Select COMPANY, \
CONTACT \
from CUSTOMERS \
where COMPANY = '%systems or software'
Version: 3.8 Build 5G (Compiled Sep 8 2003 09:23:53)
Request Opt: PRIKEY, MDKQUAL, NO_DISTINCT_MDK_KEYWD, ASKQUAL, ASKORDERBY,
AGGREGATION, ASKLINK, NO_ASKRETRIEVAL, STARSCHEMA
Required Opt: NONE
Actual Opt: MDKQUAL
Warnings: NONE
----------------------------------- DETAILS -----------------------------------
Qualify (CUSTOMERS)CUSTOMERS where COMPANY = 'systems or software' on
1 with \
NOAUTORESET
(83 CUSTOMERS, 83 Pre-intersect 0.010 CPU 0.010 Elapsed)
Fetchkeys $RECNO 1000 at a time on 1
Retrieve CUSTOMERS using $ROWID = $ODXID
Return CUSTOMERS.COMPANY, CUSTOMERS.CONTACT
-------------------------------------------------------------------------------
>
> set explain nodetails
> explain
----------------------------------- SUMMARY -----------------------------------
Select COMPANY, \
CONTACT \
from CUSTOMERS \
where COMPANY = '%systems or software'
Version: 3.8 Build 5G (Compiled Sep 8 2003 09:23:53)
Request Opt: PRIKEY, MDKQUAL, NO_DISTINCT_MDK_KEYWD, ASKQUAL, ASKORDERBY,
AGGREGATION, ASKLINK, NO_ASKRETRIEVAL, STARSCHEMA
Required Opt: NONE
Actual Opt: MDKQUAL
Warnings: NONE
-------------------------------------------------------------------------------
>
Top
|
