Re: Dramatic performance drop when table > 100MB
I'd like to withdraw the question at this time ... turns out I had a:
PRIMARY KET (col1,col2)
which I thought was creating the right indexes - but I was doing queries based on col2 - and there was no INDEX on col2.
Adding a "INDEX col2" to the table definition created the appropriate index and returned performance to normal.
Thanks,
Patrick
Subject
Written By
Posted
November 01, 2004 09:39PM
November 02, 2004 01:12AM
November 02, 2004 06:42AM
Re: Dramatic performance drop when table > 100MB
November 02, 2004 04:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.