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

Unless you use aggregate functions or keywords in the view (sum, group by, etc.), the view will be merged with the SQL statement directed at, and you'll get the exact same execution plan.

If you want to speed it up, do EXPLAIN PLAN's on the SQL and tune it, most likely with indexes.

Regards,

--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original music? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult

ramdan wrote in message ...
>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 - 22:19:07 CDT