Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Performance issues making a select on a partitioned table
PPN wrote:
>
> Hello.
>
> I am currently working on extractions from an Oracle database which
> resides on an 8 processors Sun machine.
> For one of these extractions, the table is partitioned into 32.
> Regarding performance issues, is it better to have one brutal select,
> which joins with another table, or parallel selects on the partitions
> ?
> The table is partitioned on one of the select's join columns, and the
> table is said to be fairly big (that's all I know...).
>
> Thanks for any answers.
> P.
Regarding performance issues, the key is: know thy data.
Given that you are vague on the details, The best way to know for sure is to try it. run it once straight, then with the parallel option.
Performance has so many variables, but this case (2 tables, one partioned, and an 8-way machine) seems like parallel the way to go.
HTH
Ed
-- Edward J. Prochak --- Magic Interface, Ltd. Ofc: 440-498-3700 on the web at --- http://www.magicinterface.com email: ed.prochak_at_magicinterface.comReceived on Fri Jul 12 2002 - 14:02:10 CDT