Re: Table access slow

Felipe Mart?nez wrote:
> Hi everybody!
>
> I was trying to tune some tables in my Oracle 7.3.15 database
> yesterday and I decided to modify one table that seemed to have
> chained rows. So, after surfing for a while looking for docs, I backed
> up that table, truncated it and reinserted all the rows that I had
> backed up.
> Now I have my table restored, but table access is extremely slow.
> Reports which used to generate in just 2 minutes they just won't come
> out for hours.
> The table is about 30000 rows with varchars, numbers and dates. There
> are some indexes too, but they seem alright.
>
>
> Can anybody, please tell me what's going on?
> Thank you

Reading it all, some questions:
- are you sure you did what you described, and just truncated

   the table (and not drop it - in which case you could miss indexes)? - post explain plans - even if you cannot change the statements, it can

   point in a direction with a bit more accuracy than this stabbing in    the dark.
- Did you analyze the indexes as well? Correct me if I'm wrong, but a

   ROT was to analyze the index, and estimate the table. - Did you have statistics in the first place? 7.3 CBO was not up to

   the standard of 9i/10i (which I'm currently downloading...).    In your test/acceptance environment, drop all stats and see if    performance is back to 'normal'. Only then do so in production.

-- 

Regards,
Frank van Bortel