Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: parallel queries using RULE

RE: parallel queries using RULE

From: Alvarez, Carlos <CAlvarez_at_uniFON.com.ar>
Date: Thu, 11 May 2000 14:36:34 -0300
Message-Id: <10494.105390@fatcity.com>


I think yes, using hints.

/+ PARALLEL(table_name, degree of paralelism) */

if you dont specify degree, the default degree will be used

Correct if Im wrong.

Carlos.
> ----------
> De: Thomas.Nigel_at_viaginterkom.de[SMTP:Thomas.Nigel_at_viaginterkom.de]
> Responder a: ORACLE-L_at_fatcity.com
> Enviado el: Jueves 11 de Mayo de 2000 03:26
> Para: Multiple recipients of list ORACLE-L
> Asunto: parallel queries using RULE
>
>
>
> Hi all,
>
> Can I effectively use parallel query on partitioned tables (on
> separate disks)
> using the RULE based optimizer within an Oracle8i database (8.1.5
> 64bit) ?.
>
> Thanks
>
> 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).
Received on Thu May 11 2000 - 12:36:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US