Welcome to OracleGiants.com!     

Oracle 10g DBA & Business Intelligence Resources.

Favor Indexes over Full Table Scans

Since Oracle has in some cases favored a full table scan over an index read, potentially setting the parameter for Oracle to consider indexes more frequently than full-table scans, this parameter will allow Oracle to skew its judgment for these options for the optimizer.

Recommendation: Begin by setting this parameter to 70 and if performance is better, experiment with values until around 40. This is an iterative process.


Use Xattr CloudFiler™ to dedup, encrypt and move your RMAN backups to the cloud.

Recent Posts

This site recommends Burleson Consulting for DBA Support & Consulting.

We are currently paying for accepted Oracle 10g DBA & Business Intelligence articles, scripts, tips & tricks. Send yours to the editor and we will review within three weeks.

Learn more

Editorial submissions & questions: editor@oraclegiants.com



This site is moderated by an:
Oracle Certified Professional
Oracle ACE


  Classic Car Online - The #1 spot for classic and muscle car enthusiats
2010 OracleGiants.com