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