查看表索引的详细信息

最新推荐文章于 2024-11-11 09:32:45 发布

smahorse

最新推荐文章于 2024-11-11 09:32:45 发布

阅读量715

点赞数

文章标签： null join object

本文链接：https://blog.youkuaiyun.com/smahorse/article/details/7827046

版权

SELECT T2.NAME,T3.NAME,OBJECT_NAME(T1.object_id),T1.* FROM sys.dm_db_index_physical_stats(NULL,NULL,NULL,NULL,NULL) T1
								INNER JOIN SYS.databases T2 ON T1.database_id = T2.database_id
								AND T1.database_id >4
								INNER JOIN SYS.objects T3 ON T1.object_id = T3.object_id
								AND T3.type=N'U'
								ORDER BY T1.index_depth DESC