Re: Tuning Question......

Miggins wrote:
> It cant really as the main cursor loop processes 20,000+ customers. For
> each customer a sum of specific transaction details need to be
> determined.

That's why I suggested adding more specific indices. Both of the index range scans are probably picking up way too many irrelevant rows to scan through. Or so my ancient crystal balls say.

Once you get the query and indices right, you might start looking at putting the relevant objects into their own buffer pool.

jg

--
@home.com is bogus.
Increased border security ironically increases number of illegals:
http://www.signonsandiego.com/uniontrib/20060308/news_1n8immig.html