4 / 9 Indexing: B-Tree, LSM & Inverted

SQL INDEX Performance

When does an index on a column potentially hurt performance?

A

During ORDER BY operations

B

During SELECT queries with WHERE on that column

C

During INSERT, UPDATE, DELETE operations

D

During JOIN operations