showplan Changes

The Adaptive Server 15.0 version of showplan better represents the steps performed by the query processor.

Adaptive Server changes the format of the showplan messages to better convey the shape of the query plan. Instead of the showplan messages displayed in a vertical format:

delete 
from authors 
where au_lname = "Willis" 
and au_fname = "Max"
QUERY PLAN FOR STATEMENT 1 (at line 1).

The type of query is DELETE.
        The update mode is direct.

        FROM TABLE
           authors
        Nested iteration.
        Using Clustered Index.
        Index : au_names_ix
        Forward scan.
        Positioning by key.
        Keys are:
           au_lname  ASC
           au_fname  ASC
        Using I/O Size 2 Kbytes for index leaf pages.
        With LRU Buffer Replacement Strategy for index leaf pages.
        Using I/O Size 2 Kbytes for data pages.
        With LRU Buffer Replacement Strategy for data pages.
        TO TABLE
           authors

The Adaptive Server 15.0 version of showplan displays a series of “pipes” (the “|” symbol) to distinguish each of the steps performed by the operators.

In the following query, there are three operators, EMIT, DELETE, and SCAN, so this query includes three sets of pipes to display this organization:

delete 
from authors 
where au_lname = "Willis" 
and au_fname = "Max"
QUERY PLAN FOR STATEMENT 1 (at line 1).
2 operator(s) under root

The type of query is DELETE.
ROOT:EMIT Operator
  |DELETE Operator
  |  The update mode is direct.
  |
  |  |  |SCAN Operator
  |  |  |  FROM TABLE
  |  |  |  authors
  |  |  |  Index : aumind
  |  |  |  Forward Scan.
  |  |  |  Positioning by key.
  |  |  |  Keys are:
  |  |  |       au_lname ASC
  |  |  |       au_fname ASC
  |  |  |  Using I/O Size 8 Kbytes for index leaf pages.
  |  |  |  Using LRU Buffer Replacement Strategy for index leaf pages
  |  |  |  Using I/O Size 8 Kbytes for data pages.
  |  |  |  With LRU Buffer Replacement Strategy for data pages.
  |
  |  TO TABLE
  |   authors
  |   Using I/O Size 8 Kbytes for data pages.
Note: This version of Adaptive Server also includes the ability to display showplan messages in XML.