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

What is that Oracle version number?

30,000 rows probably has no use for indexes. I'd suggest running an EXPLAIN PLAN. But I'd suggest rebuilding them if there is any reason to keep them.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)