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

Home -> Community -> Usenet -> c.d.o.server -> Performance issues making a select on a partitioned table

Performance issues making a select on a partitioned table

From: PPN <ppn_at_mederic.fr>
Date: 10 Jul 2002 00:53:25 -0700
Message-ID: <6f6a7f59.0207092353.221f8b1c@posting.google.com> 





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.
Received on Wed Jul 10 2002 - 02:53:25 CDT












Original text of this message













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