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!

When not to use PARALLEL hint in queries?

Amigo3044Nov 28 2007 — edited Nov 28 2007

Oracle 9i
=======

I have a table of over 8000k records spread over 8 partitions. I have a query that accesses all the partitions to retrieve a set of records -

DELETE FROM table WHERE pay <> 'Y'

I can't find anything to improve upon when I see the EXPLAIN PLAN...except a PARALLEL hint. Now, I want to know whether (or how) this can be detrimental to the database. There must be some trade-offs that I should take care of?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 26 2007

Added on Nov 28 2007

7 comments

821 views