Intro Recently, on Oracle 11.2.0.3, I saw a join of three tables, using three times TABLE ACCESS FULL and HASH JOIN, without an obvious reason. During separating and understanding its components, the following scenario turned out to be the culprit. select * from CARDTEST where OBJECT_ID<DATA_OBJECT_ID; The optimizer is unable to calculate the cardinality of […]
About
Martin Klier
Troubleshooter, Database integration, performance and HA specialist with 15+ years of experience. Oracle ACE Director.
co-founder of performing databases.
Your data efficiency experts.
