On Thursday 26 February 2004 13:30, David Pradier wrote:
> Hi everybody,
> i'd like to know if it exists a system of cache for the results of
> queries.
> What i'd like to do :
> select whatever_things from (selection_in_cache) where special_conditions;
> The interesting thing would be to have a precalculated
> selection_in_cache, especially when selection_in_cache is a very long
> list of joins...

You might want to search the archives for the -sql list for a message 
"Materialized View Summary" - some time this week. That's almost exactly what 
you want.

  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to