Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: parallel queries using RULE
But isn't it true that when you specify hints the cost optimizer is
invoked?
Nancy
"Alvarez, Carlos" wrote:
>
> 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).
> >
> --
> Author: Alvarez, Carlos
> INET: CAlvarez_at_uniFON.com.ar
>
> 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 - 13:50:31 CDT
![]() |
![]() |