主页 / dba / 问题 / 235454
Accepted
Anders Lindén
Asked: 2019-04-24 01:42:44 +0800 CST

具有相同 object_id 但名称不同的索引

  • 772

当我跑

SELECT
  count(object_id) AS count,
  object_id,
  min(name) as name1,
  max(name) AS name2
FROM
  sys.indexes
GROUP BY object_id HAVING COUNT(*) > 1 ORDER BY count

我将获得具有相同object_id但不一定具有相同名称的索引列表。

不应该所有具有相同名称的索引object_id都具有相同的名称吗？

sql-server t-sql

1 个回答

  1. Best Answer

    Object_ID属于索引所属的对象，例如索引视图或表。

    当您查看文档object_id中的sys.indexes

    object_id - 此索引所属的对象的 ID。

    如果要唯一标识索引，则需要Object_ID+index_id列或index_id特定的object_id.

    要验证这一点，您可以将该OBJECT_NAME()函数添加到您的查询中

    SELECT
  count(object_id) AS count,
  object_id,
  OBJECT_NAME(object_id),
  min(name) as name1,
  max(name) AS name2
FROM
  sys.indexes
GROUP BY object_id HAVING COUNT(*) > 1 ORDER BY count;
    • 8

相关问题