table access slows to a crawl
I have a simple transaction table. Two things happen to this table: we insert rows and we update rows. Rarely do we delete rows. It has about ten million rows presently. Access has really slowed down lately. We didn't have this problem at 8 million rows. Have I crossed some kind of practice limit on table size? Is there some kind of maintenance that I should do to this table?
Subject
Views
Written By
Posted
table access slows to a crawl
2186
August 14, 2006 12:39PM
1412
August 22, 2006 12:52PM
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.