Yes, it does. If you want just to get rid of deleted records, you can always coalesce the index. This is how it works: SQL> alter index scott.pk_emp coalesce; Index altered. SQL> On 04/01/2004 03:52:00 PM, dba1 mcc wrote: > index rebuild it does NOT reread from table but reread > from old index. Is it true? > -- Mladen Gogala Oracle DBA ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------