Practice
Learn
← Quit
0 / 0 correct
Databases
Hard
1 of 20
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 bitmap scan; it's prevented by sorting
C
A hash join; prevented by memory
D
A sequential scan; prevented by indexes