"Percival Boqais" <pb_at_microsoft.com> wrote in message
news:MEts8.6055$DQ6.1211196544_at_newssvr15.news.prodigy.com...
> I would say every week, 2-3,000 records are added to the 70,000 record
> table. I'm just wondering if there is some sort of limit that's been hit,
> or quota reached (tablespace?). I don't know as I'm not a DBA. Does
anyone
> else know why this would slow down? Sorry for the lack of details.
Most probably because the optimiser is choosing an inappropriate access path
for the query. This is likely to happen if statistics are not updated
regularly (the table is growing at 10% a month). never the less for specific
advice you'd need the query and execution plan(s), as well as any relevant
indexes.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Tue Apr 09 2002 - 05:41:59 CDT
