In sql server 2008, the sysindexes table contains a pointer to the first page of the index allocation mapping. If a table consists of multiple IAM pages, will the sysindexes table contain a pointer to each one of those as well, or will the first IAM page point to the second and the second point to the third and so on... ...I checked the books online but wasn't able to find any information on this.
migrated from stackoverflow.com Feb 2 '12 at 14:48
This question came from our site for professional and enthusiast programmers.
sysindexes points only at first IAM page in IAM pages chain. IAM pages chain is a doubly linked list - ie. each page in chain (obviously except first and last ones) has pointers to the next page and to previous page in its header.
Look here: Managing Space Used by Objects