Community

Access Path Selection: Evolution and Revolution

(Frank J. Ingrassia) Access path selection (APS) is the optimizer’s primary function—to choose the most efficient access path for each SQL statement executed by DB2. Access paths can be indexed or non-indexed, matching one or more columns against those indexes and/or screening predicates against col

Read More - Register for Free Membership

Tags: