This article explores the internals of Oracle9i indexing; reviews the standard b-tree index, index-only tables, and how these indexes may increase the speed of Oracle SQL queries.

A SQL Server expert gives his take on the absolute, No. 1, very worst thing IT pros can do when it comes to indexing.

Bill Vaughn provides a roundup of SQL Server 2008 indexing tips and tricks, based on advice form Kimberly Tripp and Paul Randall. The tips cover Query Optimizer selectivity and query optimization.

Indexing is a critical part of database optimization. Indexing can dramatically increase query speed. However, DBAs still struggle with finding optimal indexes or optimal SQL plans. DBTA held a ...