Re: Parallel Query Option on 7.3.4

How does one invoke Parallel Query Option ...? 1-Setting the INIT.ORA parameters necessary for (PQO) to work. 2-Alter table/index xxx parallel (degree 5); This step is to indicate/signal the table/index as Parallel with 5 Query Slaves. 3-Putting hints in your SQL statements to indicate that it should be executed in parallel.

Roman Gelfand wrote in message <71qh9p$bu0$1_at_news.monmouth.com>...
>No, but why should it matter if I am specifying the hint?
>
>
>B.Sc Yassir Khogaly wrote in message
><71qfk4$5sg$1_at_newsreader1.core.theplanet.net>...
>>This may sound stupid..but have you created the table tbl1 parallel..?
>>
>>If not alter table tble1 parallel (DEGREE x);
>>
>>Regards
>>
>>
>>Roman Gelfand wrote in message <71qf03$a93$1_at_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
>>>
>>>
>>
>>
>>
>
>

begin 666 Yassir Khogaly.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DMH;V=A;'D[66%S<VER#0I& M3CI987-S:7(@2VAO9V%L>0T*5$E43$4Z4V5N:6]R($]R86-L92!$0D$-"E1% M3#M(3TU%.U9/24-%.BLT-"@P*3$X,2 T-C T,#0R#0I414P[0T5,3#M63TE# M13HK-#0T,3$Y,#8W-S8-"D%$4CM(3TU%.CL[.SM+96YT.SM%;F=L86YD#0I, M04)%3#M(3TU%.T5.0T]$24Y'/5%53U1%1"U04DE.5$%"3$4Z2V5N=#TP1#TP M045N9VQA;F0-"E523#IH='1P.B\O=W=W+FMH;V=A;'DN9G)E97-E<G9E+F-O M+G5K#0I54DPZ:'1T<#HO+W=W=RYA965U+F]R9RYU:PT*14U!24P[4%)%1CM) M3E1%4DY%5#IY87-S:7) :VAO9V%L>2YF<F5E<V5R=F4N8V\N=6L-"E)%5CHQ <.3DX,3$P-%0R,30Y,3=:#0I%3D0Z5D-!4D0-"@`` `
end Received on Wed Nov 04 1998 - 15:49:17 CST