Query plans in Adaptive Server Enterprise 15.0

In Adaptive Server, there are two kinds of query plans:

The legacy query plans are unchanged in Adaptive Server 15.0, and their showplan output is also unchanged.

The query plans that are executed by the query engine are different from those executed by the query engine in versions of Adaptive Server earlier than 15.0. The corresponding showplan output has changed significantly as well. Some of the new features of the query plans that showplan must display include:

The rest of this chapter describes the showplan output for query plans.