SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Parallel execution tuning and Query optimization, are they inter-related?

BS2012Aug 13 2012 — edited Aug 14 2012

Hi All,

Parallel execution - Dramatically reduces response time for data-intensive operations on large databases typically associated with decision support systems (DSS) and data warehouses.

Query optimizaton - The optimizer determines the most efficient way to execute a SQL statement after considering many factors related to the objects referenced and the conditions specified in the query.

So as I guess both are doing the same thing "efficient execution or performance tuning". Please correct me if I am wrong.

Regards,
BS2012.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 11 2012

Added on Aug 13 2012

6 comments

409 views