• Depends what you are trying to do.

    Please follow the link in my signature on posting code and data for the best help.

    But with a temp table you would have to load and then read, where as a view would be a read so less going on via a view.

    That being said why not a procedure?

    What is the structure of the tables?

    What is the index definitions on the tables?

    What is the joining criteria?

    Is there referential integrity between the tables?