Rebuild clustered indexes after data move?

• Scott Williams-478043

  Grasshopper

  Points: 21

  More actions

  February 10, 2009 at 11:40 am

  #128129

  We recently moved our SQL database files to new drives on our SAN. Is is necessary to rebuild our clustered indexes?

  In other words: Do the clustered indexes retain the physical location of the record on the disk?

  Many thanks,

  --scott

• Jonathan Kehayias

  One Orange Chip

  Points: 26778

  More actions

  February 10, 2009 at 11:47 am

  #941521

  No. You can validate this by looking at the information in sys.dm_db_index_physical_stats().

  Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
  My Blog | Twitter | MVP Profile
  Training | Consulting | Become a SQLskills Insider
  Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

• Scott Williams-478043

  Grasshopper

  Points: 21

  More actions

  February 10, 2009 at 11:55 am

  #941525

  Thanks, I just wanted to validate that. My understanding of clustered indexes was partially in error.

  --scott