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 -> Rebuild Index

Rebuild Index

From: Vincent Birlouez <birlouezv_at_logica.com>
Date: 1998/03/27
Message-ID: <351BEA48.A39D6BB5@logica.com>#1/1

Hi,

I would like to rebuild some indexes (and keep the current storage parameters), there is two way (in Oracle 7.3) for doing that :

  1. Drop the index Recreate the index
  2. Rebuild the index (ALTER INDEX myindex REBUILD)

Are those two ways rebuild the index in the same fashion or is there some differences ?

Thanks ! Received on Fri Mar 27 1998 - 00:00:00 CST

Original text of this message

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