Re: Rebuilding indexes

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 5 Jun 2002 09:08:40 +1000
Message-ID: <BTbL8.5230$Hj3.16671@newsfeeds.bigpond.com>

Hi Chuck (always wanted to say that)

Generally when performing the rebuild, Oracle will perform a multiblock read of the existing index structure and doesn't navigate the index in the conventional sense (more efficient, even with sort). However, the blocks are not logically "ordered" and so the sort is required.

Richard
"Chuck" <chuckhNOSPAM_at_softhome.net> wrote in message news:adilc8$11hijm$1_at_ID-85580.news.dfncis.de...
> I noticed fro mmonitoring v$sesstat that ALTER INDEX REBUILD does a sort
> operation. Why does Oracle need to resort the index keys if it's reading
the
> source data from an existing index, and indexes are already sorted?
>
>
>
Received on Tue Jun 04 2002 - 18:08:40 CDT