摘要:
查看统计信息 SELECT object_id , OBJECT_NAME(object_id) AS TableName , name AS StatisticsName , auto_created FROM sys.stats where objectproperty(object_id,'I 阅读全文
摘要:
SELECT OBJECT_NAME(IDX.object_id) Table_Name , IDX.name Index_name , PAR.rows NumOfRows , IDX.type_desc TypeOfIndexFROM sys.partitions PARINNER JOIN s 阅读全文