Updating oracle statistics


17-Mar-2016 13:00

Oracle Database automatically maintains optimizer statistics. You can maintain optimizer statistics manually using the package.

For example, you can save and restore copies of statistics.

The choice of executions plans made by the Oracle SQL optimizer is only as good as the Oracle statistics.

updating oracle statistics-67

rsvpdating com au

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 more information about AUTO_CREATE_STATISTICS, see ALTER DATABASE SET Options (Transact-SQL).



Below are some best practice we highly recommend you follow: Facebook Insights provides developers and site owners with metrics about their content.… continue reading »


Read more

Meet people, singles, groups, make contacts in the free meeting place.… continue reading »


Read more