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 […]
Tag: dbms_xplan
Oracle: Recreate PLAN_TABLE
drop table plan_table; @?/rdbms/admin/utlxplan.sql […]