See Twitter's SQL.
49 points by ptm
Read the article
Discussion on Hacker News