Wait a Minute! RE:A technical question about VIEWS

On 13 Apr 1997 17:15:29 GMT, "Olen" <orkline_at_txdirect.net> wrote:

>The view's query is not dynamic, you are building an intermediate table. A
>view reacts like a subquery. It always
>returns the same solution set regardless of what else you specify in the
>query. So the answer is that Oracle will first create the view will 10,000
>rows. Then process the rest of the query against it.
>
> That's how I understand it.

Wait a minute! I am a fan of Oracle, but this doesn't make sense! How can _ANY_ DBMS make a claim to be production-worthy and _NOT_ take into consideration the rest of a query when a view is used in a query when building the first result set? How else can it know how to optimize the comepete querry?

Or is it just taken for granted that Oracle is a sub-optimized DBMS when it comes to using views?

What am I missing here? (I am a former MainFrame DBA, if it helps you to see where I am comming from.) Received on Mon Apr 14 1997 - 00:00:00 CDT