RailsConf 2017: The Secret Life of SQL: How to Optimize Database Performance by Bryana Knight

RailsConf 2017: The Secret Life of SQL: How to Optimize Database Performance by Bryana Knight There are a lot of database index and query best practices that sometimes aren’t best practices at all. Need all users created this year? No problem! Slap an index over created_at! What about this year’s active OR pending users, sorted by username? Are we still covered index-wise? Is the query as fast with 20 million users? Common rules of thumb for indexing and query crafting aren’t black and white. We’ll discuss