View Mechanics

From: Lange, Kevin G <kevin.lange_at_ppoone.com>
Date: Thu, 1 Sep 2011 17:11:33 -0500
Message-ID: <F077F09A0E11504D9E720358BEE994D1088A4B83_at_APSW0553EVS.ms.ds.uhc.com>



I am just curious if its common for an Explain Plan of a view to have a totally different response than an explain plan of the SQL behind the view.  

Reason being, we have a very simple view made of of 3 tables that, when you explain it, it shows full table scans on all three tables. But, in the mean time, if you explain plan the SQL behind the view, you get index range scans on all three tables.  

Just makes no sense to me (which seems to be happneing more and more these days).  

System: Oracle 10.2.0.4 on a Solaris 10 machine. This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 01 2011 - 17:11:33 CDT

Original text of this message