sql-server - 为什么 sys.indexes 表有一个 NULL 索引名称？

Question

我运行了这个查询:

SELECT
    i.name                  AS IndexName,
    s.used_page_count * 8   AS IndexSizeKB
FROM sys.dm_db_partition_stats  AS s 
JOIN sys.indexes                AS i
ON s.[object_id] = i.[object_id] AND s.index_id = i.index_id
WHERE s.[object_id] = object_id('dbo.Stu')
ORDER BY i.name

并且返回的最大索引的名称为 NULL。这是什么意思？

Answer 1

来自sys.indexes :

Name of the index...
NULL = Heap

所以这些都是堆。