creating and droping temptable to speed up the query?

[waely]

hi,
I have report that is generated from joining three views. one view takes forever which slowes down the overall performance of the report. is it recommended to maybe create that table on the fly as #tempTable then join it with the other views then drop it ?

if yes, can someone give me an code demonstrating how I can create that table, join it with other tables then drop it? thank you very much.

waely

[si_the_geek]

Putting the data into a temp table will probably not help - as you still need to read everything from the view.

Probably the best thing to do is optimise the "slow" view if you can.

If you give us some details (such as what DBMS you are using, the code from the view, ..) we can suggest ways to do that.

[waely]

thank you