Page History
...
It is possible to perform the following actions on the Execution Plan tree:• The
- The Playback controls, located at the top of the tree enable you to freely move within the Execution Plan of an explained statement.
...
- By moving the pointer over the Execution Plan steps, you can view a ToolTip that contains statistical information, such as Estimated Cost and Estimated Rows of the specified step.
...
- Selecting a specific step will highlight its sons and affect the information displayed in the information tabs.
...
- Clicking the plus sign (+) located at the bottom of the tree, displays the statement's text.
...
Available operation options
...
The following options are available to different operations:• Clustered
- Clustered index - the leaf pages of the index hold the actual data, instead of RIDs (Records ID). A table without a clustered index is called a Heap.
...
- Non-clustered index - the index consists only of the columns that combine the key and a pointer to the records in the table data. If the table has a clustered index, then the pointer is the key of the clustered index. If the table does not have clustered index, then the pointer is an RID.
There are several operations for accessing indexes or tables:• Seeking
- Seeking - the index tree can be used for quickly locating the matching records. Seeking can only be done on indexes.
...
- Scanning - The leaf pages of the index or the data pages of the table are consecutively scanned.
NOTE Seeking is the recommended way to use indexes.
...