anoop.mig29 (4/8/2013)
Table are allocated extents,then why why index are allocated pages . can index size becomes soo huge that they have to be allocated extents?
Tables and indexes are both allocated pages, a set of 8 contiguous pages aligned on a 64k boundary is called an extent. It's not a special structure, just 8 pages. The allocations to both indexes and tables are pages.
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability