Re: Performance ok only after recreaction of a table

You may have suffered from
excessive chaining (rows in more than one block) index degradation.
Chaining can be caused by updates, with the record getting longer, it can result from the record by design being longer than the block size. In this case the only thing that really helps is recreating the database with a bigger block size.
Your problem is definitely NOT a bug.

Hth,

--
Sybrand Bakker, Oracle DBA
Marco De Benedetto <dibe_at_galliera.it> wrote in message news:38188997.BEAB8700_at_galliera.it...
> Oracle 7.2.3 on AIX
> I had very very bad performance on a (simple) query
> I don't even know if it would have ended since it took
> too much time and I had to stop it (ctrl+C)
>
> After the export/drop/import of one of table involved
> there were no change,
>
> The solution has been to
> . create table new as select * from old
> . drop old
> . rename new to old
>
> does anybody knows if it is a known bug and what can
> cause such a thing?
>
> thanx
>
> -debe
Received on Thu Oct 28 1999 - 14:43:15 CDT