RE: partitioning question

That is correct. RBO will always generate a full table scan, even if it could be
resolved by searching a single partition only.

-----Original Message-----
From: Chris Griffith [mailto:Chris.Griffith_at_dstm.com] Sent: Tuesday, May 09, 2000 5:32 PM
To: Multiple recipients of list ORACLE-L Subject: RE: partitioning question

Oracle has been stating for years that RULE based optimization is going to be obsolete, so my guess is they haven't developed for this to be used with partitioning.

-----Original Message-----
Sent: Tuesday, May 09, 2000 3:19 PM
To: Multiple recipients of list ORACLE-L

That's a very interesting question. Have you tried it yet? I'd be curious to
know what happened.

Thomas.Nigel_at_viaginterkom.de on 05/09/2000 12:14:13 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Lisa Koivu/GELCO)

Hi all,

Can anybody give a definitive answers to these questions:

Will 8.1.5 running under the RULE based optimiser recognise that a table or index has been partitioned, and thus access only the some partitions to get the
required data for the query?

IF NOT Will I have to use a hint combined with statistics to make use of this facility?

Regards

Nigel T

--
Author:
  INET: Thomas.Nigel_at_viaginterkom.de

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).






-- 
Author: 
  INET: Lisa_Koivu_at_gelco.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).
-- 
Author: Chris Griffith
  INET: Chris.Griffith_at_dstm.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