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