Search posts, tags, users, and pages
Akshat Jain
Software Engineer at Yugabyte
Introduction 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...
Sameer Raj
One of the use cases of EXPLAIN is estimating the number of rows in your table. select count() from table1 is costly, alternatively, explain select count(*) from table1 will give an estimated result much faster.
Such an informative and well-written blog! Rooting for more such blogs.
Sameer Raj
One of the use cases of EXPLAIN is estimating the number of rows in your table. select count() from table1 is costly, alternatively, explain select count(*) from table1 will give an estimated result much faster.