Is it an option for you to maintain a set of tests which simulate behavior on the tables?<p>I&#x27;ve have great success doing this with datawarehouses (i.e. star schema, large tables with few writes). You run the tests after each index change on acceptance. It caught a errors.<p>For OLTP it&#x27;s harder, you need to record some production workload and reply it. At your scale it&#x27;s easier said than done, though.