Oracle's heuristics previously avoided considering fixed tables for Join Predicate Pushdown (JPPD) transformation, leading to suboptimal plans. Enforcing predicate pushing into the view with the PUSH_PRED hint was a workaround. Oracle addressed this in the 21c release, evaluating fixed tables for JPPD. Continue Reading → The post Performance Improvement on Dictionary Views in Oracle 21c appeared first on All-round Database Topics.| All-round Database Topics
PL/SQL, C, Python and Java handle bind variable length differently. As a consequence, different execution plans could be generated when the same query runs from different programming languages. Continue Reading → The post Bind Variable Length in PL/SQL, C, Java and Python appeared first on All-round Database Topics.| All-round Database Topics
Analysis of dataset properties leading to a bad performance problem with a simple fix. Continue Reading → The post A Data Model Fix for Suboptimal Semi-Join and Anti-Join Cardinality Estimates appeared first on All-round Database Topics.| All-round Database Topics