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

For example, a SQL query requiring 10,000 rows to be presented in sorted order will often use a b-tree index to avoid the very large sort required to deliver the data to the end user.