Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete fast
mccmx_at_hotmail.com says...
> >
> > 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';
>
> Thats a good idea... but you will double the space usage during the
> index rebuilds.
The additional space you will need is roughly the size of the largest index that you rebuild. If you haven't got enough spare space to rebuild a large index, you have a problem more serious than fast deleting.
GM Received on Wed Jun 28 2006 - 18:22:08 CDT