22,301
社区成员




CREATE TABLE TB (ID INT PRIMARY KEY NOT NULL)
GO
INSERT TB SELECT 1
GO
CREATE VIEW V
AS
SELECT * FROM TB
GO
SET SHOWPLAN_TEXT ON
GO
SELECT * FROM V WHERE ID=1
/*StmtText
-----------------------
SET SHOWPLAN_TEXT ON
(所影响的行数为 1 行)
StmtText
-----------------------------
SELECT * FROM V WHERE ID=1
(所影响的行数为 1 行)
StmtText
-------------------------------------------------------------------------------------------------------------------------
|--Clustered Index Seek(OBJECT:([dbdb].[dbo].[TB].[PK__TB__5008A86A]), SEEK:([TB].[ID]=Convert([@1])) ORDERED FORWARD)
(所影响的行数为 1 行)