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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Cardinality Hint

biswachkMay 7 2009 — edited May 7 2009

Hi Experts,

Can any of you please tell me when to use cardinality hint in sql code. As far as I know " The cardinality hint is used in two general cases, complex joins and dynamically created tables like global temporary tables" - but I think the hint can be used for other reason as well.

An ex-employee has wriitten the following code - but I am not sure what the cardinality hint is doing here

SELECT /*+ cardinality (df 100) */ c.c_id,
c.number,
mcc.code,
df.trans_date
FROM dp_enquiries de,
dp_files df,
dp_cases c,
mag_committees mcc
Can you please explain?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 4 2009

Added on May 7 2009

11 comments

19,804 views