Re: Performance issues on tables with >10000 inserts a day

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