title: Is querying on views slower than doing one query?
body: <p>Will Mssql be even fast when I query on a view opposed to one query?</p>
  
  <p>example </p>
  
  <p>When I have this view:</p>
  
  <pre><code>create view ViewInvoicesWithCustomersName
  Select * from Invoices left join Customer on Customer.ID=Invoices.CustomerID
  </code></pre>
  
  <p>What will be faster or will it be even fast?</p>
  
  <pre><code>a) select * from ViewInvoicesWithCustomersName where customerName="Bart"
  b) select * from Invoices left join Customer on Customer.ID=Invoices.CustomerID
     where customername="Bart"
  </code></pre>