Dropping partition will affect index?
Hello,
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.
Veera.
Subject
Written By
Posted
Dropping partition will affect index?
November 17, 2014 07:42AM
November 18, 2014 09:32AM
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.