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 5, “Access Methods and Query Costing for Single Tables.”
