Chapter 23: Accessing Methods and Costing for Joins and Subqueries

This chapter introduces the methods that Adaptive Server uses to access rows in tables when more than one table is used in a query, and how the optimizer costs access.

In determining the cost of multitable queries, Adaptive Server uses many of the same formulas discussed in Chapter 22, “Access Methods and Query Costing for Single Tables.”