Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> A technical question about VIEWS

A technical question about VIEWS

From: NNOOR <Nnoor_at_cris.com>
Date: 1997/03/27
Message-ID: <5hco8f$f85@chronicle.concentric.net>#1/1

I know what views are. I want to know how views handle queries which run against them. Is the view first built and then user's query is satisfied from the result set (ofcourse, when NOT running SELECT *), or the view is built only for the records which also satisfy user's query--i.e. dynamically changing it's query. Following example will explain the question I am trying to ask...

Lets say a view is built by joining x tables. And if the Select * is run for the view then, say, it returns 10,000 rows. Now if a query is run against the view with a selection criteria which will result in, say, only 10 rows. How will Oracle handle this situation. Will it first create the view with 10,000 rows and then run the user's query on the result set or it will dynamically add the selection criteria to the view's query so that a result set with only 10 records is built?

I am trying to establish that how "expensive" the view operation is for internal application development purposes...

Thanks very much for your help!

Regards,
Nasir (nnoor_at_cris.com) Received on Thu Mar 27 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US