Easy way you can analyze and optimize your SQL queries to get the best performance out of them.
Reference: thoughtbot.com/blog/reading-a...
🥹 If you found this helpful, follow me online here:
✍️ Blog / irtizahafiz
👨💻 Website 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
4 июл 2024