Apr 21, 2025 · 16 min read · Each of us frequently interacts with databases, whether we are developers, data analysts, or system administrators. However, have we ever truly considered the intricate processes that occur when our queries are executed by the database's execution en...
Join discussion
Feb 8, 2025 · 4 min read · Execution plan Execution Plan (chiến lược thực thi) câu lệnh là giải thuật của dbms để thực thi một câu lệnh SQL. Nó cho ta biết là dbms thực thi câu lệnh SQL đó bằng cách nào. Thông thường, các dbms đều có câu lệnh để xem chi tiết chiến lược thực ...
Join discussion
Dec 7, 2024 · 4 min read · Lateral join joins a subquery, which is executed as many times as there are rows in the leading table. Consider it as a kind of for-each loop. Most of, if not all, the problems it solves, can also be solved without lateral join (e.g. using analytic f...
Join discussionOct 13, 2024 · 5 min read · 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...
Join discussionDec 26, 2023 · 6 min read · 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...
Join discussion
Sep 1, 2023 · 12 min read · 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...
Join discussionAug 30, 2023 · 6 min read · 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...
Join discussion
Aug 28, 2023 · 2 min read · 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...
Join discussion
Jul 24, 2023 · 11 min read · 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 ...
Join discussion
Nov 6, 2022 · 7 min read · 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...
AAlex commented