We can simply add and drop partitions from table as we are dropping and creating a new table. While dropping and adding table partition , we need to take care of the index too. In previous post we saw simply removing partitions makes index unusable. For Reference Drop Table Partition without Index Maintenance and SKIP_UNUSABLE_INDEXES […]
Articles Tagged: index maintenance
Drop Table Partition without Index Maintenance and SKIP_UNUSABLE_INDEXES parameter
In this article we will see how we can drop the PARTITION without any index maintenance at run time and doing it later. I have following partitions available for my table TRANSACTIONS_NEW. I have one index on it on date_of_transaction column : Let us drop partition Y_2014 Let us check index status : We can […]