> The tables are not partitioned but we are using RAID 10 striped and > mirrored. Are parallel and partitioning 'locked ' together? Is their no > value to parallel unless the tables are partitioned? We are moving > toward it but haven 't done it yet.
No, parallel and partitioning are NOT locked together. However, in some
cases, using parallel operations on partitioned objects can give additional
benefit (partition-wise joins etc..)
Tanel.
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
