How to use oracle optimizer hints for tuning
What is Optimizer? When a query is submitted in Oracle server. optimizer attempts to generate the best execution plan for a SQL statement. The best execution plan is defined as the plan with the lowest cost among all considered candidate plans. The cost computation accounts for factors of query execution such as I/O, CPU, and …
How to use oracle optimizer hints for tuning Read More »
