sql索引组织

select p.*, p.partition_id,  c.object_id,OBJECT_NAME(c.object_id) objectName,c.name,c.column_id,pc.max_inrow_length,pc.system_type_id,pc.leaf_offset
From sys.system_internals_partition_columns pc
join sys.partitions p
  on pc.partition_id = p.partition_id
  join sys.columns c
   on pc.partition_column_id = c.column_id
   and c.object_id = p.object_id
   where p.object_id = object_id(‘Fixed‘)
   可以获得堆的偏移

注意:system_internals_partition_columns 目前似乎只对堆表中的偏移有效，其它索引会返回固定值，因为是微软内部调试函数，不会确保返回结果一致或正确
   Select * From sys.indexes where object_id= object_id(‘Fixed‘)

sql索引组织

原文：http://www.cnblogs.com/thaughtZhao/p/4274517.html