title: difference between view and indexed view or materialized view
body: <p>I am confused in these two and tried to figure out the differences but didn't get something specific for which I am looking for.</p>
  
  <ul>
  <li>Where to use indexed view over an ordinary view.</li>
  <li>Some important differences between them.</li>
  </ul>