What is the meaning of file here?

• forsqlserver

  SSCoach

  Points: 18902

  More actions

  May 25, 2011 at 11:20 pm

  #240352

  The below statement is from Microsoft DBCC Indexdefrag page:

  "If an index spans more than one file, DBCC INDEXDEFRAG defragments one file at a time. Pages do not migrate between files."

  What is the meaning of file here?

  I have heard that pages exists inside extent.

  refer:http://msdn.microsoft.com/en-us/library/ms177571.aspx

  Thanks

• ModestyBlaise84

  SSCommitted

  Points: 1931

  More actions

  May 26, 2011 at 12:28 am

  #1330076

  All objects, including indexes, are created on file groups. Each file group consists of one or more files.

  These files could be primary and secondary. (Talking about data files)

  If a file group consists of more than one file and index is created on that file group it could (and will) be spread across these files.

  I believe that these files are files mentioned in the link you are referring to.

  Hope that someone will correct me if I am wrong.