RE: Views and indexes

From: Lyall Barbour <lyallbarbour_at_sanfranmail.com>
Date: Mon, 1 May 2000 20:07:24 -0400 (EDT)
Message-Id: <10484.104638@fatcity.com>

Find out using Explain Plan.

Lyall Barbour

------Original Message------
From: "Kimberly Smith" <KSMITH1_at_gmd.fujitsu.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: May 1, 2000 11:19:35 PM GMT
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 subscribing).

______________________________________________
FREE Personalized Email at Mail.com
Sign up at http://www.mail.com/?sr=signup

Received on Mon May 01 2000 - 19:07:24 CDT