SET Options

EXPLAIN

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