A proposed index speeds one report but significantly increases write cost. What should guide the decision?

Published
  1. Judge only the index's name
  2. Create every suggested index without evaluating overlap
  3. Measure the read benefit against write, storage, and maintenance overhead for the whole workload
  4. Assume indexes never affect writes

Comments — 0