context

From: Thapliyal, Deepak <DThapliyal_at_ea.com>
Date: Mon, 1 May 2000 18:28:13 -0700
Message-Id: <10484.104642@fatcity.com>

greetings list members

is there a quick way of finding whether context option is installed

thx in advance

-----Original Message-----
From: Lyall Barbour [mailto:lyallbarbour_at_sanfranmail.com] Sent: Monday, May 01, 2000 6:14 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Views and indexes

Find out using Explain Plan.

Lyall Barbour

------Original Message------
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: May 1, 2000 11:19:35 PM GMT

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

-- 
Author: Lyall Barbour
  INET: lyallbarbour_at_sanfranmail.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).

Received on Mon May 01 2000 - 20:28:13 CDT