Tuesday, April 6, 2010

Make the Oracle Optimizer Smarter And Your Queries Faster

Most Oracle DBAs know this, but us programmers may not be aware that the Oracle query optimizer doesn't automatically periodically scan its data to make sure the choices it makes are accurate for the data that's in the tables.  Without doing so, the wrong indexes may be chosen, or full table scans may be run instead of far more optimal index searches.  To force the index metadata to be updated, run the following query:
analyze table TABLE_NAME compute statistics;
More Information

No comments:

Post a Comment

AddThis

Bookmark and Share