Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Dropping Large Indexes

Re: Dropping Large Indexes

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Tue, 29 Aug 2006 13:29:29 -0500
Message-ID: <de807caa0608291129w6a1f3129xe5592e4509f255d4@mail.gmail.com>


Anand,

Tim Gorman (http://www.evdbt.com/) has worked miracles by using EXCHANGE PARTITION. As I understand it, a local index is exchanged with the partition / table. I don't know if this would cure your performance issue, but there may be a creative way to utilize this facility. Internally, Oracle just changes some pointers so is is nearly instantaneous.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 29 2006 - 13:29:29 CDT

Original text of this message

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