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: Nancy McCormick <nancy.mccormick_at_sbti.com>
Date: Thu, 11 May 2000 13:50:31 -0500
Message-Id: <10494.105402@fatcity.com>


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

Original text of this message

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