On volumes with multiple disk spindles, Adaptive Server Anywhere can scan tables using an index in parallel. Parallel index scans let the server take advantage of tables and index pages across multiple disks to schedule multiple input/output operations at the same time. Each scan carried out in parallel searches for rows matching a different key and ensures that these pages are in memory when needed.
NoteParallel index scans are not supported over compressed indexes and not at isolation level 3. |