AMDP- INNER Join With Cardinality

light111Join with Cardinality


It is possible to mention the cardinality with the join in the sql script, which is basically a HINT that increases the performance. Below we have INNER JOIN one with no cardicality and one with cardinality. The result are same but the JOIN with cardinality helps the sql optimizer and improves the query performance.

The test program-

The debug details-

Debug Result-

Below – ONE TO MANY cardinality with INNER JOIN.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s