Tag
index-scan
- Nov 13, 2024 The Crossover Between an Index Scan and a Sequential Scan Why fetching a few percent of a table by index can cost more than reading all of it, how physical correlation moves the crossover point, and what bitmap scans change. databases
- Jul 3, 2024 Physical Operator Selection and Access Path Mechanics What distinguishes a sequential scan from an index scan, a bitmap heap scan from an index-only scan, and how each access path decides when to stop reading. databases