SET STATISTICS PROFILE ON
select * from t1
where id='001'
SET STATISTICS PROFILE OFF
-----------执行后能看到有层次结构的检索结构-----------
SELECT * FROM [t1] WHERE [id]=@1
|--Nested Loops(Inner Join, OUTER REFERENCES:([DB_Name].[dbo].[t1].[key]))
|--Index Seek(OBJECT:([DB_Name].[dbo].[t1].[UQ_t1]), SEEK:([DB_Name].[dbo].[t1].[id]=[@1]) ORDERED FORW