EXPLAIN: make it make sense by Aivars Kalvāns at 154th Database focused DevClub.lv

Most developers know how to measure the time a database query takes and to find which one is the slowest. But what next? What is going on there? Is it good that it’s doing that? Is the query supposed to take this much time? Will some indexes help? In this talk, Aivars Kalvāns helps you decipher database query plans and give some rules of thumb to understand if the database is doing the best it can. He also uses query plans to find the best indexes for queries by observing what the database is looking for. He also shares several anti-patterns He has seen in projects and show how to rewrite them in a database-friendly way. Although He uses Python to explain the principles and execute His queries, He shows the raw SQL to make it applicable to any programming language. Aivars Kalvāns is a FinTech developer, software architect, and consultant. He spent more than 18 years developing and architecting payment card software for acquiring and issuing, as well as for accounting and utility payments, through mobile phones, ATMs, and POS terminals. At the moment, he is a contractor exploring Foreign Exchange, SWIFT, SEPA, ledgers, and other areas of the FinTech landscape. 🌐 Language – English Subscribe to our channel, so you don't miss our videos on the most relevant topics from real professionals🔥 Learn more about "Nine Brains" high-quality courses by world-class trainers ⬇️ https://ninebrains.eu You can follow us on: ➡️LinkedIn   / devclub-lv   ➡️Facebook   / devclublv