请问查询视图会造成二次查询吗

[Coffcer]

视图：
SELECT a.Id,b.Name FROM table AS a INNER JOIN table1 AS b ON a.Id=b.Id
查询：
SELCT * FROM 视图 WHERE Id = 5

请问这个查询等同于
SELCT * FROM
(SELECT a.Id,b.Name FROM table AS a INNER JOIN table1 AS b ON a.Id=b.Id)
WHERE Id = 5

还是说等同于
SELECT a.Id,b.Name FROM table AS a INNER JOIN table1 AS b ON a.Id=b.Id WHERE a.Id = 5

[winner2050]

SELCT * FROM (SELECT a.Id,b.Name FROM table AS a INNER JOIN table1 AS b ON a.Id=b.Id) WHERE Id = 5 和 SELECT a.Id,b.Name FROM table AS a INNER JOIN table1 AS b ON a.Id=b.Id WHERE a.Id = 5 完全一样。

[Coffcer]

引用 1 楼 winner2050 的回复:

SELCT * FROM (SELECT a.Id,b.Name FROM table AS a INNER JOIN table1 AS b ON a.Id=b.Id) WHERE Id = 5 和 SELECT a.Id,b.Name FROM table AS a INNER JOIN table1 AS b ON a.Id=b.Id WHERE a.Id = 5 完全一样。

我以为前者是先取出所有数据再筛选，后者是只取出符合的数据，难道不是这样吗

[种草德鲁伊]

看执行计划.

[H_Gragon]

查询视图跟查询表一样！