Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: parallel queries using RULE
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
![]() |
![]() |