Tag Archives: drop partition

Dropping an Empty Partition Without “Update Indexes” Necessary

As we know  the ‘update indexes’ clause is used  to drop the local indexes and update the global index  when we drop a partition. So the indexes will still be VALID” The below example shows when we drop an empty … Continue reading

Posted in Partitioning | Tagged , , , | Leave a comment