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.

VoltDB is one example—a distributed, in-memory, massively parallel NewSQL relational database that clearly shows that SQL can be made to scream.