Re: dropping indexes

  • From: Haroon Qureshi <haroon.qureshi@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 12 Aug 2010 17:21:49 -0500

Sorry, forgot to mention this is on 10.2.0.4.

Haroon

On Thu, Aug 12, 2010 at 5:16 PM, Haroon Qureshi
<haroon.qureshi@xxxxxxxxx> wrote:
> Hello,
>
> I have two indentical partitioned tables.  The volume of data is the
> same in both tables and the indexes are identical as well.  When I
> drop the indexes (all of them) on the tables, one of the tables takes
> less than 5 minutes to do so (about 30 indexes).  The other table
> would take about 20 minutes to do so.
>
> Can anyone help explain this or point me in the right direction to
> figure out what is going on?
>
> Thanks in advance for your help.
>
> Haroon
>
--
//www.freelists.org/webpage/oracle-l


Other related posts: