Indexing....The Good, The Bad, and the Ugly

Indexes are the easiest way to improve the performance of long running queries with full table scans.  Indexes allow the database to search the smaller indexes as opposed to searching the large table.  This can improve not only the SELECT queries, but also UPDATEs and DELETEs.

Finding the most efficient index is difficult.  Most indexes will be the default B_Tree type.  This type of index has been in use for years and has been highly optimized.

Having too many indexes will slow down performance of updates and inserts.  Too few indexes and all types of queries may run slower (even updates and deletes).  If it were just a trade off, performance of updates and inserts verses performance of selects, optimizing indexes in a database would be fairly easy.  However, it is not that simple.

Learn secrets for finding balance when index planning:

http://www.remote-dba.net/t_index_types_frequency.htm

*****************************************
Can you see your Oracle bottlenecks?

After several years of hard work, Ion for Oracle is finally available for general release.  Ion is unlike any other Oracle tool on the market, a tool that encapsulates expert techniques to allow a DBA to quickly visualize important trends and signatures.

Predictive analytics if the key to repairing Oracle problems before they cripple your database, and I created Ion for Oracle to allow any DBA to quickly identify changing workloads and unobtrusive patterns of data access.  To try Ion for free, see here:

http://www.ion-dba.com

*****************************************
DBA-Oracle.com now has a site search feature

 Due to popular request, we have now implemented Google site search, a quick way to locate all salient articles on this web site!

To find our articles on other web sites, many people simply append “Burleson” to their search strings. 

We hope that you find this new feature useful in your quest for expert Oracle information.

http://www.dba-oracle.com   

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

Need a Health Check?

Oracle is the world's 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