Optimize Your SQL Queries | Postgres Edition

hqdefault 123

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

Reference:

🥹 If you found this helpful, follow me online here:
✍️ Blog
👨‍💻 Website
📲 Instagram

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

By: Code with Irtiza
Title: Optimize Your SQL Queries | Postgres Edition
Sourced From: www.youtube.com/watch?v=sJN5UwC60bM

Follow us on FB: https://www.facebook.com/UXClub.net/

Leave a Reply