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 -> Re: Delete fast

Re: Delete fast

From: <mccmx_at_hotmail.com>
Date: 28 Jun 2006 05:46:16 -0700
Message-ID: <1151498776.687831.235740@d56g2000cwd.googlegroups.com>


> 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

Original text of this message

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