AJAkshat Jaininblog.akjn.dev·Oct 24, 2023 · 16 min readExplaining and Analysing Postgres EXPLAIN ANALYSEIntroduction SQL is a declarative query language. That means, you tell it what you want, you do not tell it how it's supposed to get it. This blogs aims to give an intuition about how a query is internally run (on a very high-level). Understanding th...02S
AJAkshat Jaininblog.akjn.dev·Sep 19, 2023 · 8 min readCorrelated Subqueries and Why You Need To Know ThemIntroduction Let's say you have 2 tables: table1: Having a column col1 table2: Having a column col2 create table table1 (col1 int); create table table2 (col2 int); Let's discuss a query: select * from table1 where col1 in (select col1 from table...07PJTAA