> I had in mind the extra tables that an application sometimes needs to
> operate faster. Denormalisations, pre-joined tables, pre-calculated
> results, aggregated data. These are not temporary tables, just part of
> the application - multi-user tables that stay across shutdown/restart.
You could also add caching search results for easy pagination without
redoing always entirely on each page the Big Slow Search Query that every
website has...