Hypercharge SQL with histograms

The distribution of values within an index will often affect the cost-based optimizers (CBOs) decision whether to use an index or perform a full-table scan to satisfy a query.  But most people don't understand that histograms are also important for helping the Oracle optimizer choose the proper table join order.

Read my notes here and see how column histograms can hypercharge your SQL:

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

For complete details, see my book "Oracle Tuning: The Definitive Reference":

http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm 

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

Ignite for SQL Server and Oracle.

Performance tuning based on wait time information has proven itself to be the best practice for Oracle.  Now Confio Software has expanded their Igniter Suite to include SQL Server Wait-Time analysis as well.  Igniter Suite users can continuously monitor and get insight into the SQL wait times and how to resolve them for Oracle and SQL Server, with DB2 right around the corner.   This tool is simple to install, get a free trial and be solving problems in 30 minutes.  

 http://www.confio.com/ora2

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

Is your Database Healthy?

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

BC 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 me at 800-766-1884 for details, and check-out our on-site Oracle training catalog:

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