Tag Archives: oracle sql tuning

filter(NULL IS NOT NULL)

“filter(NULL IS NOT NULL)” in explain plan usually means what CBO found a conflict between your WHERE-clause predicates and declarative constraints on the tables involved. example – And if constraints are validated, Oracle does not physically touch the Object at … Continue reading

Posted in Oracle, SQL | Tagged , , , | Leave a comment