Community

Optimizer Statistics with DBMS_STATS in Oracle 10g

When a SQL statement is executed, the database must convert the query into an execution plan and choose the best way to retrieve the data. For Oracle, each SQL query has many choices for execution plans: –Including which index to use to retrieve table row. –What order in which to join mult

Read More - Register for Free Membership

Tags: