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

Home -> Community -> Usenet -> c.d.o.misc -> Parallel Query Option

Parallel Query Option

From: Roman Gelfand <rgelfand_at_masmid.com>
Date: Wed, 4 Nov 1998 16:21:34 -0500
Message-ID: <71qgcs$b2f$1@news.monmouth.com>


select /*+ PARALLEL(TBL1, 5) */ fld1, fld2, fld3, fld4 from tbl1 order by fld5, fld6;

The table tbl1 contains 5000 rows. Can anyone tell me why I am not seeing performance improvement using parallel query option.

Thanks for your help Received on Wed Nov 04 1998 - 15:21:34 CST

Original text of this message

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