title: Select from view takes too long
body: <p>I have a query against a table that contains like 2 million rows using linked server.</p>
  
  <pre><code>Select * from OPENQUERY(LinkedServerName,
  'SELECT
   PV.col1
  ,PV.col2
  ,PV.col3
  ,VTR.col1
  ,CTR.col1
  ,PSR.col1
  FROM 
  LinkedDbName.dbo.tbl1 PV
  INNER JOIN LinkedDbName.dbo.tbl2 VTR 
  ON PV.col_id = VTR.col_id
  INNER JOIN LinkedDbName.dbo.tbl3 CTR 
  ON PV.col_id = CTR.col_id
  INNER JOIN LinkedDbName.dbo.tbl4 PSR 
  ON PV.col_id = PSR.col_id
  WHERE
  PV.col_id = ''80C53C9B-6272-11DA-BB34-000E0C7F3ED2''')
  </code></pre>
  
  <p>That query results into 365 rows and is executed within 0 second.
  However when I make that query into a view it runs for about minimum of 20 seconds and sometimes it reaches to 40 seconds tops.</p>
  
  <p>Here's my create view script</p>
  
  <pre><code>CREATE VIEW [dbo].[myview]
  AS
  Select * from OPENQUERY(LinkedServerName,
  'SELECT
   PV.col1
  ,PV.col2
  ,PV.col3
  ,VTR.col1
  ,CTR.col1
  ,PSR.col1
  FROM 
  LinkedDbName.dbo.tbl1 PV
  INNER JOIN LinkedDbName.dbo.tbl2 VTR 
  ON PV.col_id = VTR.col_id
  INNER JOIN LinkedDbName.dbo.tbl3 CTR 
  ON PV.col_id = CTR.col_id
  INNER JOIN LinkedDbName.dbo.tbl4 PSR 
  ON PV.col_id = PSR.col_id')
  </code></pre>
  
  <p>then</p>
  
  <pre><code>Select * from myview where PV.col_id = '80C53C9B-6272-11DA-BB34-000E0C7F3ED2'
  </code></pre>
  
  <p>Any idea ? Thanks !</p>