-
Rebuilding Index post dropping partition
Hi,
we are exchanging the trailing partition to a non partitioned table. In the code I saw that
1) Copy some records (20%) from the trailing partition to a temporary table
1) then it is exchanging the traling partition with another table (non partitioned)
2) Then it is rebuilding the unusable local index on trailing partition
3) then it is dropping the traling partition
Ques #1) since we are dropping the traling partition, to me the step 2 is not reuired. Is that correct?
but with that note I would also like to say that, once the traling partition has been droped the code copy above 20% records from the temporary table to the NEW trailing partition.
Ques# 2: Does the activity requiresrebulilding unusable local index?
Rgds
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|