Page History
...
The table below describes the available operation options.
Table 9-2 Operation 2 Operation options
Operator Description
...
Merge joins A Merge Join algorithm is used to join two tables by merging them. Merge Join algorithms read both tables only once; therefore it is required that the input be sorted according to the Join predicates. Merge Joins are available in Precise for Sybase from version 12.0 and above. This option is grayed-out by default. To enable it on session level, execute the set sort_merge on command. See the Sybase Help for more details on how to enable Merge Joins on server level.
About the operators that are available in the plan tree
The table below describes the operators that are available in the Plan tree.
Table 9-3 Operation 3 Operation options
Operator Description
...
Log Scan This operator indicates that a log scan operation was performed.
About the costs that are available in the plan tree
...
The table below shows the I/O Cost information operators available in the Plan tree.
Table 9-4 I4 I/O cost information operators
...
Scan Count A "scan" can represent any of these access methods:• A
- A table scan.
...
- Access using a clustered index. Each time the query starts at the root page of the index and follows pointers to the data pages, it is counted as a scan.
...
- Access using a non-clustered index. Each time the query starts at the root page of the index and follows pointers to the leaf level of the index (for a covered query) or to the data pages, it is counted.
...
- If queries run in parallel, each worker process access to the table is counted as a scan.
Estimated Rows Number of rows from the current table that is estimated to satisfy the join.
...
The Objects tab displays three tables (Tables used in the plan, Indexes of table, and Columns of table) that list all referenced objects in the Execution Plan, including their indexes and columns. Statistical details and general details are displayed for each object and its sub-entities.
About tables used in the plan
...
The table below describes the information displayed in the tables used in the plan.
Table 9-5 Tables 5 Tables used in the plan
Column Description
Click to launch the Objects tab and focus on the specified table.
...
Displays a list of all the indexes of the selected table displayed in Tables Used in the Plan. The table below describes the information displayed in indexes of table.
Table 9-6 Indexes 6 Indexes of table
Column Description
...
Clustered Indicates whether the index is clustered.
About Columns of Table
Displays a list of all columns in the selected table displayed in Tables Used in Plan. When an index is selected in Indexes of Table, the first column constitutes the index column sorted by the position of the column in the index, and marked with an Ascending or Descending icon.
The table below describes the information displayed in the columns of the table.
Table 9-7 Columns 7 Columns of table
Column Description
Indicates whether the column is part of the selected index and whether it is sorted in ascending or descending order.
...
The table below shows the statistical information displayed for Operator ID and Type.
Table 9-8 About 8 About viewing statistics on Operator ID and Type
...