Join 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-
Below – ONE TO MANY cardinality with INNER JOIN.