A proposed clustering change improves one query but creates ongoing maintenance cost. What should determine adoption?

Published
  1. Only whether the key has the longest name
  2. Measured workload-wide benefit relative to maintenance cost
  3. Only the shortest single observed runtime
  4. A belief that all large tables require manual clustering

Comments — 0