Summary: An alternate approach, offered in response to our original post…, provides excellent improvements for smaller databases, but clustered indexes offer better performance as database size increases. (This posting is by Dave.)

Jay Pipes suggested an alternate approach to

A couple of weeks ago, Baron Schwartz wrote an interesting post… describing a rule of thumb he sometimes uses to choose the order of columns in an index. In a nutshell, he recommends putting highly selective columns first. This is

Executive Summary: A query like TPC-H Query 17 can be sped up by large factors by using straight_joins and clustering indexes…. (This entry posted by Dave.)

In a previous post, we wrote about queries like TPC-H query 2, and

This post is for storage engine developers that may be interested in implementing multiple clustering keys.

After blogging about TokuDB’s multiple clustering indexes feature, Baron Schwartz… suggested we contribute the patch to allow other storage engine to implement the feature.

I recently posted a blog entry on clustering indexes…, which are good for speeding up queries. Eric Day brought up the concern that clustering indexes might degrade update performance. This is often true, since any update will require updating

In this post we’ll describe a query that accrued significant performance advantages from using a relatively long index key. (This posting is by Zardosht and Bradley.)

We ran across this query recently when interacting with a customer (who gave us…