ANALYZER PLAN ID
Syntax
ANALYZER PLAN ID query_id [NODE nodeid]
Privileges
DBADMIN
Description
The ANALYZER PLAN ID command is used to gather information about the indexes used in the query plan of a query execution. Usually a SCAN tablename entry in the detail column, indicates that no indexes are found and a full table scan must be performed. The NODE argument forces the execution of the command to a specific node of the cluster.
Return
A Rowset with an analysis about the query id.
Example
> ANALYZER PLAN ID 57
----|--------|---------|----------------|
id | parent | notused | detail |
----|--------|---------|----------------|
2 | 0 | 0 | SCAN customers |
----|--------|---------|----------------|