title: Is there a way to cache a View so that queries against it are quick?
body: <p>I'm extremely new to Views so please forgive me if this is a silly question, but I have a View that is really helpful in optimizing a pretty unwieldy query, and allows me to select against a small subset of columns in the View, however, I was hoping that the View would actually be stored somewhere so that selecting against it wouldn't take very long.</p>
  
  <p>I may be mistaken, but I get the sense (from the speed with which <code>create view</code> executes and from the duration of my queries against my View) that the View is actually run as a query prior to the external query, every time I select against it.</p>
  
  <p>I'm really hoping that I'm overlooking some mechanism whereby when I run CREATE VIEW it can do the hard work of querying the View query *then, so that my subsequent select against this static View would be really swift.</p>
  
  <p>BTW, I totally understand that obviously this VIEW would be a snapshot of the data that existed at the time the VIEW was created and wouldn't reflect any new info that was inserted/updated subsequent to the VIEW's creation.  That's actually EXACTLY what I need.</p>
  
  <p>TIA</p>