title: MySQL Views - When to use & when not to
body: <p>the mysql certification guide suggests that views can be used for:</p>
  
  <ul>
  <li>creating a summary that may involve calculations</li>
  <li>selecting a set of rows with a WHERE clause, hide irrelevant information </li>
  <li>result of a join or union</li>
  <li>allow for changes made to base table via a view that preserve the schema of original table to accommodate other applications</li>
  </ul>
  
  <p>but from <a href="https://stackoverflow.com/questions/1480953/how-to-implement-search-for-2-different-table-data/1481204#1481204">how to implement search for 2 different table data?</a></p>
  
  <blockquote>
    <p>And maybe you're right that it doesn't
    work since mysql views are not good
    friends with indexing. But still. Is
    there anything to search for in the
    shops table?</p>
  </blockquote>
  
  <p>i learn that views dont work well with indexing so, will it be a big performance hit, for the convenience it may provide? </p>