Re: Delete fast

> Rather than dropping them:
>
> cursor my_indexes is
> select INDEX_NAME
> from USER_INDEXES
> where TABLE_NAME = <table name>;
> for mi in my_indexes loop
> execute immediate 'alter index '||mi.index_name||' unusable';
> end loop;
> execute immediate 'alter session set skip_unusable_indexes = true';
> ... do the deleting ...
> for mi in my_indexes loop
> execute immediate 'alter index '||mi.index_name||' rebuild';
> end loop;
> execute immediate 'alter session set skip_unusable_indexes = false';
>
> Geoff M

Geoff

Thats a good idea... but you will double the space usage during the index rebuilds.

Matt Received on Wed Jun 28 2006 - 07:46:16 CDT