Conor vs. Views/Tables

I received an email from a reader this weekend that has a lot of different questions, but one of the main questions related to the difference between views and base tables in SQL Server’s plan generation process.  ie if I have a view “select * from table” vs. a table “table”, does the optimizer treat…

2