title: SQL: View with Filter inside or View with Filter on Select
body: <p>I have been working on a database that uses a lot of views and the table records are only upto 1 million rows but it has been a pain waiting for my queries to show up.</p>
  
  <p>I wanted to duplicate the View and put a "WHERE CLAUSE" inside. Now to my question:</p>
  
  <p>Is it faster to put a where clause inside a view. For example I would put all customer type = 'BIZ'.</p>
  
  <p>or Would it be the same if I just use the View "SELECT * FROM VIEW_CUSTOMER WHERE type = 'BIZ'"</p>