Our Database Had 2 Million Rows. Queries Took 8 Seconds. I Added 3 Indexes. Now It Takes 12 Seconds
Share

Why more indexes made things worse, composite index order actually matters, and the EXPLAIN output I ignored for 6 months

 

 Why more indexes made things worse, composite index order actually matters, and the EXPLAIN output I ignored for 6 monthsContinue reading on Engineering Playbook » Read More Sql on Medium 

#sql

By ali