Performance issues on tables with >10000 inserts a day

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