This website uses cookies to ensure you get the best experience.
Learn more.
A proposed index speeds one report but significantly increases write cost. What should guide the decision?
Published
- Judge only the index's name
- Create every suggested index without evaluating overlap
- Measure the read benefit against write, storage, and maintenance overhead for the whole workload
- Assume indexes never affect writes
Comments — 0
Sign in to comment