Urh Srecnikblog.srecnik.info·Dec 7, 2024Introduction to JOIN LATERAL on OracleLateral 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...52 readsOracle
Urh Srecnikblog.srecnik.info·Oct 13, 2024Reading Execution PlansI 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...58 readsOracle Database
Metismetis.hashnode.dev·Dec 26, 2023Reading Postgres Execution Plans doesn't have to be so complicatedIn 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...SQL
DataWisokadatawisoka.com·Sep 1, 2023Optimizing your Postgres: Indexing and Execution PlansQuery 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...PostgreSQL
Pavlo Datsiukpavlodatsiuk.hashnode.dev·Aug 30, 2023A Quick Guide to Analyzing Microsoft SQL Server Execution PlanMicrosoft 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...239 readsSQL Server
Itay Braunpostgres.hashnode.dev·Aug 28, 2023Visualization of MySQL Execution PlansBy 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...36 readsdb-tools
Krishnaraj Venkatesankrishnaraj.hashnode.dev·Jul 24, 2023The Secrets of MySQL Query Execution PlansAre 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 ...65 readsdatabase
Itay Braunpostgres.hashnode.dev·Nov 6, 2022Reading Postgres Execution Plans doesn't have to be so complicatedBy 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...4 likes·81 readsexecution plan
