USE Northwind
go
SET ANSI_NULLS,QUOTED_IDENTIFIER ON
go
CREATE VIEW dbo.MyEmployeeView 
AS
    SELECT *
      FROM pubs.dbo.employee
     WHERE emp_id = 'JYL26161F'

USE Northwind
go
select  *
from    dbo.MyEmployeeView

StmtText	StmtId	NodeId	Parent	PhysicalOp	LogicalOp	Argument	DefinedValues	EstimateRows	EstimateIO	EstimateCPU	AvgRowSize	TotalSubtreeCost	OutputList	Warnings	Type	Parallel	EstimateExecutions
select  * from    dbo.MyEmployeeView	1	1	0	[NULL]	[NULL]	1	[NULL]	1	[NULL]	[NULL]	[NULL]	0.0126592	[NULL]	[NULL]	SELECT	0	[NULL]
  |--Bookmark Lookup(BOOKMARK[Bmk1000]), OBJECT[pubs].[dbo].[employee]))	1	3	1	Bookmark Lookup	Bookmark Lookup	BOOKMARK[Bmk1000]), OBJECT[pubs].[dbo].[employee])	[employee].[hire_date], [employee].[pub_id], [employee].[job_lvl], [employee].[job_id], [employee].[lname], [employee].[minit], [employee].[fname], [employee].[emp_id]	1	0.00625	1.1e-006	49	0.0126592	[employee].[hire_date], [employee].[pub_id], [employee].[job_lvl], [employee].[job_id], [employee].[lname], [employee].[minit], [employee].[fname], [employee].[emp_id]	[NULL]	PLAN_ROW	0	1
       |--Index Seek(OBJECT[pubs].[dbo].[employee].[PK_emp_id]), SEEK[employee].[emp_id]='JYL26161F') ORDERED FORWARD)	1	4	3	Index Seek	Index Seek	OBJECT[pubs].[dbo].[employee].[PK_emp_id]), SEEK[employee].[emp_id]='JYL26161F') ORDERED FORWARD	[Bmk1000]	1	0.0063285	7.96e-005	53	0.0064081	[Bmk1000]	[NULL]	PLAN_ROW	0	1