Drop or Rebuild Indexes with MANY MANY extents

Hi Tom, We are upgrading an 8174 database to 10203 and doing some maintenance beforehand. I discovered a partitioned table with 4 locally parititoned indexes. The table is OK but the index partitions were created mainly with 16k extents. The lar...

Read More...

---