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.

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.

Q&A Denny Cherry's Top Tips for Indexing SQL Server Tables A SQL Server expert gives his take on the absolute, No. 1, very worst thing IT pros can do when it comes to indexing. By Becky Nagel 10 ...

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 ...

How to Reindex SQL Tables. The indexes on a the tables of a large database make a huge difference in its performance and utility. Without an index, locating a single record in a large table can ...

Aerospike, Inc., the real-time database for mission-critical use cases and workloads, is debuting new expression indexes-or a method of indexing that simplifies application code-that supercharge query ...

I've got a stored procedure that runs a FTI query against a table. If there's no activity on the server for a while then the first time that procedure is called it times out; subsequent calls work ...