Reaching consensus on index rebuilding?
 

Over the years, there have been heated discussions about the benefits of scheduled rebuilding of Oracle indexes.  In this great discussion on OTN we see some excellent observations about Oracle indexes, including Richard Foote who has an OOW presentation on advanced index internals.

Here are some generally-accepted observations about Oracle indexes:

"Each of the four EVA virtual disks contained a VxFS file system. One file system was used to back up each of the VGs. Using a large block size yielded best performance; however, it is least efficient for space utilization"

Read more about recent observations about index rebuilding:

http://www.dba-oracle.com/t_index_rebuilding_issues.htm

*****************************************

Need a Health Check?

Oracle is the worlds most complex and robust database and there are hundreds of sub-optimal setting that can cripple your database performance.

Burleson Consulting has a great Oracle health check where we identify all database bottlenecks to ensure that your mission-critical system is running at optimal speeds.

Just call 800-766-1884 to schedule your health check.

*****************************************

Need Oracle Training?

The very best Oracle training comes from Burleson Consulting, where you get an on-site visit by an experienced Oracle expert and author.  Whether it's one-on-one mentoring or getting a customized on-site Oracle training class, there is no substitute for BC Oracle training.  Just call 800-766-1884 for details, and check-out our on-site Oracle training catalog at the following link:

http://www.dba-oracle.com/bc-catalog.pdf