Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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