Reading some values in sys.dm_db_index_physical_stats
-
Hi all Please see the attached picture for my problem. Basically I have run a query to view the indexes for a particular object and 2 clustered indexes are returned, one seemingly LOB data. Is there something wrong here, how can there be 2 clustered indexes with the same index_id on a single object?
I do not full understand alloc_unit_type_desc or the index_depth columns so maybe its to do with that?
-
in BOL you can find more information about what LOB_DATA means:
"The LOB_DATA allocation unit contains the data that is stored in columns of type text, ntext, image, varchar(max), nvarchar(max), varbinary(max), and xml."
index_depth - it is information how many levels are in index tree structure
-
This is the MSDN/BOL link to explain all about LOB_DATA, IN_ROW_DATA and so on: http://msdn.microsoft.com/en-us/library/ms187501(SQL.90).aspx
The link that explains all about tables and indexes is: http://msdn.microsoft.com/en-us/library/ms180978(SQL.90).aspx
Start with the Table and Index Organization section.
Paul
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply