title: How do indexes work on views?
body: <p>Can someone please explain to me in simple English how an index on a view works?  I have a fairly simple understanding of indexes on tables; how would indexing a view work differently from just letting the indexes on the underlying tables do their thing naturally?</p>