Re: partitioning question

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)

Subject: partitioning question

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