In certain cases I have used temporary tables in order to speed up reports.  In these cases, the queries are usually complex and the backend and / or front end are being run in a multiuser environment with multiple users accessing the reports at any given...

read more