Easy way you can analyze and optimize your SQL queries to get the best performance out of them.

Reference: https://thoughtbot.com/blog/readinga...

If you found this helpful, follow me online here:
✍ Blog   / irtizahafiz  
‍ Website https://irtizahafiz.com
 Instagram   / irtiza.hafiz  

0:00 Agenda
01:15 Difference between EXPLAIN & EXPLAIN ANALYZE
02:35 How count of returned rows affect performance
04:15 How to monitor index usage
10:30 Aggregation queries using indexes
13:37 Information about JOIN algorithms
18:15 ORDER BY using Index forward and backward
20:56 How to read query plans
22:10 Outro

#database #mysql #postgres