If I have a view, and embed the view in a query, will the view have to be processed fully before the rest of the query?
Example:
CREATE VIEW dbo.ExpensiveView AS
SELECT IndexedColumn, NonIndexedColumn
FROM dbo.BigHairyTable
WHERE NonIndexedColumn BETWEEN 500000000 AND 500050000
GO
SELECT * FROM dbo.ExpensiveView
WHERE IndexedColumn BETWEEN 1000 AND 1099
GO