I routinely do a "rehearsal" of my presentations with our DBA team and any other willing participants (they tend to be developers) to receive feedback and to share knowledge. In the last one, I've got quite an interesting question, which requires und...
In this blog post, we’ll see What is an SQL Execution Plan? Why it is important Which tools can we use to read the plan What is an SQL Execution Plan? Postgres documentation says: The execution plan shows how the table(s) referenced by the state...
Query performance is a critical factor in the efficiency and scalability of any database-driven application. Whether you're dealing with a small web app or a large-scale enterprise system, slow queries can become bottlenecks that degrade user experie...
Microsoft SQL Server is a powerful and widely used relational database management system that efficiently stores and retrieves data for various applications. One of the critical aspects of optimizing the performance of SQL queries is understanding an...
By Itay Braun, CTO, Metis Execution Plan: Unraveling the Blueprint of Database Queries An execution plan is a detailed strategy that a database management system (DBMS) devises to carry out a specific query. It outlines the sequence of operations and...
Are your MySQL queries not performing as well as expected? Understanding the various execution plans provided by the MySQL query planner can significantly improve your database's performance. In this blog, we'll discuss different execution plans for ...
By Itay Braun, CTO, Metis Main Subjects What is an Execution Plan. Key differences between the Actual and Estimated ones. As a backend developer, why should you care, even if an ORM is used and you don't control the SQL. A curated list of great...
