From: William P. <wil...@ya...> - 2010-04-23 14:50:16
|
On Apr 23, 2010, at 9:58 AM, Jon Auman wrote: > If we fine tune the query, we see that the indices are taking over Hmm.. at some point we added a bunch of indices in a effort to improve performance. I wonder if the alarming growth from 50GB to 90GB occurred as a results of adding indices? In which case this increase would be a "one-off" big jump, and therefore future growth would, hopefully, not be so alarming. Is there a way to know which indices have a valuable improvement in performance and are just wasting disk space? bp |