I'm looking for general guideline on the use of temporary tables.
I would like to use temporary table as a caching mechanism to speed up
queries within the same session. Specifically, a temporary table is
created to store a subset of data from a possibly large table, and
subsequent queries select from the temporary table instead of
re-applying the same complex filters on the actual table again and
again.
Is this what temporary table is designed for? Are there caveats that I
should be aware of? Can you think of other better alternatives?
Thank you very much.