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.