EXPLAIN
Explain the approach to the last executed statement.
Syntax
EXPLAIN [statement] [WITH options]
EXPLAIN
Required.
statement
Optional. SQL select statement
WITH options
Optional. A comma separated list of options to apply to this command.
Options
Example
> select company, contact from customers where company='systems'
...
> explain
----------------------------------- SUMMARY -----------------------------------
Select COMPANY, \
CONTACT \
from CUSTOMERS \
where COMPANY = 'systems' \
with OPTIMIZATION='ASKQUAL'
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
-------------------------------------------------------------------------------
OR
> explain select company, contact from customers where
company='systems'
----------------------------------- SUMMARY -----------------------------------
Select COMPANY, \
CONTACT \
from CUSTOMERS \
where COMPANY = 'systems' \
with OPTIMIZATION='ASKQUAL'
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
|