which is faster to do over an dover a select with join or a view that does ajoin

I have a web page where people ask for info that quieres several tables. one piece of info requires a join of two tables.

what will be faster and or more efficent an

        1 - an SQL select that does a join and gives the results
        2 - a view that presents the result of the join

since this info is going to be asked mulipte times a minute which is better will having it in a view make it quicker to get? Received on Wed Jul 28 1999 - 21:02:48 CDT