OraFAQ Forum: Performance Tuning » Question on indexes

Home » RDBMS Server » Performance Tuning » Question on indexes

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Question on indexes [message #65499]

Thu, 07 October 2004 13:48

Martin
Messages: 83
Registered: February 2000

Member

Hello all

Could an Index be disabled. If so, could you please tell me how.

I have a table with 50 million rows. What would be the time taken to add a new index to this table.

�

Thanks

Martin

Report message to a moderator

Re: Question on indexes [message #65501 is a reply to message #65499]

Thu, 07 October 2004 22:01

Deepak Panda
Messages: 24
Registered: May 2004

Junior Member

You can not disable indexes. Rather you drop the index and recreate it.

Hope this helps.

Report message to a moderator

Re: Question on indexes [message #65502 is a reply to message #65499]

Fri, 08 October 2004 04:20

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

or
You can make your indexes unusable.
after the load rebuild your indexes.

Report message to a moderator

Previous Topic:	Never ending explain plan
Next Topic:	Does compute statistics and Coalesce Tablespace Imporve Performance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 17:59:28 CST 2025