This tip explains the order in which the alternative SQL statements are displayed in the Tuning Lab.
After the optimization process is finished, the SQL alternatives are displayed in the order of the...
In this SQL Optimizer for SAP ASE video, we demonstrate how the Configuration Analyzer evaluates the effect of configuration changes on SQL performance before those changes are actually committed....
In an earlier article we discussed two very popular reasons, LOAD_OPTIMIZER_STATS and HASH_MATCH_FAILEDpushing Oracle to refuse sharing an existing execution plan and, thereby, hard parsing a new plan...