Performance on table with > 10000 inserts a day

Hi all, A question : How do you manage a 14 million row table which grows at the rate of 8000 - 14000 rows a day? This table has 7 indexes and is obviously heavily used. Most online transactions are pretty effective since the bulk of them are inserts. Retrieving a few rows is also effective, since we have so many indexes to cater to them. The problem lies in the batch or daily processing which takes hours. Some aggregate queries take 5 - 6 hours. If I drop and re-create the indexes and re-run the query, it only takes 15 minutes. And of course, dropping and re-creating the indexes takes 5 hours and is effective for just a couple hours, before the inserts split them up again. What is the best way to manage these index pages, or is it just a waste of time ? I have other such tables but haven't even started looking at them yet. Thanks for any suggestions Sujata -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own