Re: Index Rebuild <was SQL*Loader and DCL

Andy Hardy wrote:

> How does an index rebuild differ to a straight create - is it faster,
> etc?

  Compared to dropping the index and using the CREATE INDEX command, re-creating an existing index offers better performance.

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response 
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841