How to fix Cardinality Problems in Oracle

One of the most critical aspects of an Oracle Execution plan is the Cardinality Estimates, as they influence all of the Optimizer's other decisions. But what should you do if you find a Cardinality Misestmate in your execution plan? In this video, I explain the 5 leading causes of Cardinality Misestimates and what you can do to correct them.
TOC
Missing or stale statistics 0.18
Data Skews 0.37
Multi-column predicates 2:16
Function wrapped columns 4:20
Complex predicates 6:15

[@mdo2480]

Very well explained. I really love the way you explain things. Many thanks

[@venkat5125]

Very useful.

[@marcinbadtke]

thank you