Practice
Learn
← Quit
0 / 0 correct
Databases
Hard
1 of 10
A query uses an index in staging but a sequential scan in production. A likely reason?
A
Sequential scans are always faster
B
Production has no indexes
C
The planner's statistics show the predicate matches a large fraction of rows, where a sequential scan is cheaper
D
Indexes are disabled in production