Dropping partition will affect index?
Posted by: Veerasamy Kaunder
Date: November 17, 2014 07:42AM


Does dropping one of the partitions from a range partitioned table affect or impact on index or any data fetching performance ?

I have a huge table with cores of records and they are present in multiple partitions. I would like to know if there is any side effects on table in case of deleting selective partitions rather than deleting records with delete query and where clause.

Thanks in advance to help here.


Options: ReplyQuote

Written By
Dropping partition will affect index?
November 17, 2014 07:42AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.