The Cost of Indexing 1.5 billion Rows

Database indexing is an effective way to improve query performance before considering more complex solutions like partitioning or sharding. Most devs have likely typed CREATE INDEX idx_* at least once and experienced the consequences of both over-ind...