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!

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

21,375 views