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
