Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Mailing Lists ->
Oracle-L ->
Re: partitioning question
Re: partitioning question
Rule based optimization is not available for partition
so you have to use hint.
- Lisa_Koivu_at_gelco.com wrote:
> 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).
Do You Yahoo!?
Received on Tue May 09 2000 - 15:03:56 CDT
Original text of this message