Discussion Board

Oracle Transaction Oracle optimizer determines the best possible way to execute a query. The query optimizer (called simply the optimizer) is a built-in database software that determines the most efficient method for a SQL statement to access requested data. The optimizer attempts to generate the best execution plan for a SQL statement. The optimizer determines the best plan for a SQL statement by examining multiple access methods, such as full table scan or index scans, and different join methods such as nested loops and hash joins. Because the database has many internal statistics and tools at its disposal, the optimizer is usually in a better position than the user to determine the best method of statement execution. For this reason, all SQL statements use the optimizer. Prajakta Pandit 02-20-2017 12:59 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*