The create view does not access the data at all. It just create an object in
the data dictionary.
What you need to compare is 'select * from view' against doing the select
from sqlplus.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Ehresmann, David wrote:
So why would the sql statement used to create a view run faster
(significantly) than selecting from that view built with the same sql
statement?
thanks,
David Ehresmann
David,
A view is a STORED object, which means that it executes using a plan
which was
Run autotrace or sql_trace and determine if the execution plans are
different. If they are the same, increase the sql_trace level and find
out what the wait events are.
--
Daniel W. Fink
http://www.optimaldba.com
IOUG-A Live! April 27 - May 1, 2003 Orlando, FL
Sunday, April 27 8:30am - 4:30pm