Practice
Learn
← Quit
0 / 0 correct
Databases
Hard
1 of 231
What is a covering index scan in Postgres called, and what can prevent it?
A
An index-only scan; it still needs to check the visibility map, so a table with many recently modified pages visits the heap anyway
B
A hash join; prevented by memory
C
A bitmap scan; it's prevented by sorting
D
A sequential scan; prevented by indexes