Drop Table Partition with Index Maintenance

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 […]

Read More