Neoview Query Guide (R2.2)

Figure 2-1 Visual Query Planner
5. Select File > Save to save your query execution plan. VQP does not automatically save plans.
If you want to review the plans later, you must save them. The default name for the session
appears in the Save dialog box. If you choose to provide a different name for the query
execution plan, the new name appears on the title bar. You do not need to connect to the
Neoview database or ODBC to open saved plans.
In the query plan, each operator has an icon next to it. The icon represents the Operator Group
to which the operator is associated:
OperatorOperator GroupOperator Icon
FILE_SCAN INDEX_SCAN
SUBSET_DELETE SUBSET_UPDATE
DAM Subset
CURSOR_DELETE
CURSOR_UPDATE
FILE_SCAN_UNIQUE
INDEX_SCAN_UNIQUE
UNIQUE_DELETE
UNIQUE_UPDATE
DAM Unique
SAMPLE SEQUENCE TRANSPOSEData Mining
ESP_EXCHANGE
PARTITION_ACCESS SPLIT_TOP
Exchange
EXPLAINStored Function
22 Using Visual Query Planner