Execution Plans, Hints and Outlines in Oracle 18c

Today's post is about execution plans. This quick example using the HR sample schema, highlights the importance of using SQL Hints to influence the execution path.Let me use below SQL as an example:SELECT     COUNT(*)FROM    hr.employees a,    hr.departments b,    hr.locations cWHERE    a.department_id = b.department_id    AND b.location_id = c.location_id    AND a.salary > 3000    AND c.postal_code IS… Continue reading Execution Plans, Hints and Outlines in Oracle 18c