Full Table Scans are Evil

... there are nearly 300,000 records in the MASTER_TBL, but the execution plan indicates a cardinality of merely 3. So, there is something?s serious wrong somewhere. First suspect is table and index statistics. As suspected, statistics on MASTER_TBL were botched up... more »
Categories: OracleSQL, 11g, 10g
PermalinkPermalink