Tag: Hash Join

Oracle 12c – Adaptive Query Optimization

Scenario: A user complains that a batch job that is critical for the month end business processing is taking more time than expected. As a DBA you quickly check and identify the sql statement that is running, compare the current execution…

Read More >