Index management in a partitioned table
Posted by:
Rathi Rao
Date: September 29, 2016 12:14AM
Hi,
I have a partitioned table. It has 2 partitions. The business requirement is such that I have to truncate partitionA and insert data into it and the other partition, parititionB, I have to just insert the data.
This is all working fine. What I need to understand is how do the indexes work?
1. So, when I truncate partitionA would all the entries in the index belonging to partitionA be erased?
2. After I truncate the partitionA would all enteries for the index related to partitionA be created again (during insert)?
3. Even thought the index statement does not require mentioning partitions, internally its managed as 2 indexes, am I right?
4. Will the index related to parititionB is updated/deleted/inserted as and when data is fed into it?
Thanks in advance
Rathi
Subject
Views
Written By
Posted
Index management in a partitioned table
2454
September 29, 2016 12:14AM
1361
October 02, 2016 12:40PM
1152
October 03, 2016 11:59PM
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.