Excuse my stupid answer but ... why not trying a UPDATE STATISTICS HIGH on this
table ...
ssoman@omm.com wrote:
> Hi all, I have some high use tables which get 10,000 or over inserts per
> day. Also, most of these tables have 5 or more indexes. My problem is dealing
> with performance on these tables. Online queries returning single or a few
> rows are not a problem, but the batch processess take a few hours, with
> single aggregate queries taking over 5 hours. If I drop and re-create all
> indexes, then the same query takes 10 minutes. The table was already
> re-organized into its own dbspace and is down to 4 chunks ( with index ), so
> the data is as organized as can be ( for now ). So, my question is, how does
> one go about managing a monster like this? Is it worth the time at all, since
> the index re-creation itself could take hours. Can the index ever be
> effective with so many inserts ??
>
> Sujata
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own