title: Speed on querying view in MySQL
body: <p>Say, I have a view, call it view1,  with data from 2010 to 2015.
  and another view, call it view2, with data from 2011 to 2012. </p>
  
  <p>i wanna know if there will be a big difference on querying the 2 views in the following cases.</p>
  
  <pre><code>1, select * from view2;
  2, select * from view1 where date between 2011 and 2012;
  </code></pre>
  
  <p>The result will be the same set of data.
  if selecting data from views with certain conditions will really slow down the speed, why? If not, please also explain. Thank you.</p>