Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Rebuilding indexes

Rebuilding indexes

From: Chuck <chuckhNOSPAM_at_softhome.net>
Date: Tue, 4 Jun 2002 11:12:07 -0400
Message-ID: <adilc8$11hijm$1@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 - 10:12:07 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US