Difference between index REBUILD Partition = ALL and Index REBUILD

• nikhil.desai1

  SSCommitted

  Points: 1948

  More actions

  August 14, 2014 at 9:54 am

  #289913

  Hi,

  I have below partitioned index on order table with below details

  Index IDPartition NumberTable Name Index Name Index Type Fragmentation

  7 9 Orders IX_Orders NONCLUSTERED 91.26293135

  7 10 Orders IX_Orders NONCLUSTERED 98.49753181

  1 9 Orders IX_Orders_TranIDCLUSTERED 90.836162

  1 10 Orders IX_Orders_TranIDCLUSTERED 98.98676254

  Please let me know what is the difference between below two script

  ALTER INDEX IX_OrdersON Table REBUILD Partition = ALL

  and

  ALTER INDEX IX_OrdersON Table REBUILD with (ONLINE = on)

  i.e.

  ALTER INDEX IndexName ON Table REBUILD Partition = ALL

  and

  ALTER INDEX IndexName ON Table REBUILD with (ONLINE = on)

  whether it is a clustered index or non-clustered index

  Thanks and Regards,

  Nikhil Desai