Page History
...
Table 6-6 Information displayed in the Plan tab
Columns Description
...
| Columns | Description |
|---|---|
 | Click to launch the SQL tab with the selected entity, to continue your analysis of the selected statement or batch. |
| Entity Name (such as Statement) |
...
| Displays the name of the entity. | |
| Database |
...
| Identifies the database on which the statement or batch is run. |
...
| User | Displays one of the Sybase users by whom this statement was executed. If this statement is not part of a stored procedure, this user will be used as parsing user when explaining this batch. |
| Most Recent |
...
| Plan | Indicates the last time the access path of the statement or batch was changed. |
| Last Show |
...
| Plan | Indicates the last time the statement or batch was explained. |
| Cost |
...
| Indicates the total estimated cost of the statement's or batch's execution. |
| Table |
...
| Scan | Indicates whether a table scan was performed in the execution plan (applicable to Statement entity only). |
| Clustered Index |
...
| Scan | Indicates whether a clustered index scan was performed in the execution plan (applicable to Statement entity only). |
| Clustered Index |
...
| Seek | Indicates whether a clustered index seek was performed in the execution plan (applicable to Statement entity only). |
| Index |
...
| Scan | Indicates whether an index scan was performed in the execution plan (applicable to Statement entity only). |
| Index |
...
| Seek | Indicates whether an index seek was performed in the execution plan (applicable to Statement entity only). |
| Table |
...
| Lookup | Indicates that a table lookup operation was performed in the execution plan (applicable to Statement entity only). |
...
| Sort | Indicates whether a sort operation was performed in the execution plan (applicable to Statement entity only). |
| Merge |
...
| Join | Indicates whether a merge join operation was performed in the execution plan (applicable to Statement entity only). |
...
| Join | Indicates that a join (other than merge join) operation was performed in the execution plan (applicable to Statement entity only). |
| Nested Loops |
...
| Join | Indicates whether a nested loops join operation was performed in the execution plan (applicable to Statement entity only). |
| Parallel |
...
| Access | Indicates whether a parallel access operation was performed in the execution plan (applicable to Statement entity only). |
| Show Plan |
...
| Errir | Shows the error that occurred during the last explain process. |
Collapsed Statement and Collapsed Batch entities Association area
The following tabs are displayed in the Association area of the Collapsed Statement and Collapsed Batch entities:
...