Q:

Creating temporary tables perl cgi dbi

I have sql containing 8 table joins which takes time to fetch the data considering the amount of joins in the sql. I could create a temp table and simply the sql which might help speed up the data retrieval process. 
i am trying to fetch the data using this sql in perl cgi dbi. Does it makes sense to create a temp table on a web application? 

A:

I have certainly used temp tables in SQL for a web application before.  The web application part really doesn't have anything to do with it.  Would a temp table make your SQL more efficient?  You'd have to be a lot more specific with your question for us to tell.

