RE: Views and indexes

From: Djordje Jankovic <djankovic_at_corp.attcanada.ca>
Date: Tue, 23 Jan 2001 12:22:53 -0500
Message-Id: <10750.127295@fatcity.com>

Hi Kimberly,

You are right. If the view definition has a set operation (this includes the "union (all)") the where condition from the query using the view is not merged with view definition. So, your indexes are not being used. As somebody mentioned you can double check this by running the explain plan.

Djordje

		-----Original Message-----
		From:	root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf
Of Kimberly Smith
		Sent:	Monday, May 01, 2000 7:20 PM
		To:	Multiple recipients of list ORACLE-L
		Subject:	Views and indexes

		Hi,
		I have two views that are being joined.  Both these views
contain a union
		all in them.
		The base tables of the view have an index against them.  The
where clause of
		the select against the joined views uses these columns.
However, I do not
		believe that it does indeed use the indexes when joining the
views.  Am I
		correct in this thought process?

		---------------
		Kimberly Smith
		EDS/Fujitsu
		Gresham, Oregon
		Work: 	503-669-6050
		Email: kimberly.smith_at_gmd.fujitsu.com
			kimberly.smith_at_eds.com
		-- 
		Author: Kimberly Smith
		  INET: KSMITH1_at_gmd.fujitsu.com

		Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
		San Diego, California        -- Public Internet access /

Mailing Lists         

---

                To REMOVE yourself from this mailing list, send an E-Mail message

                to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

		the message BODY, include a line containing: UNSUB ORACLE-L
		(or the name of mailing list you want to be removed from).
You may
		also send the HELP command for other information (like

Received on Tue Jan 23 2001 - 11:22:53 CST