Search posts, tags, users, and pages
Develop intuition on how SQL queries are being run!
Akshat Jain
@akjn · India
Software Engineer at Yugabyte
Backend software engineer from India. Love databases, cloud technologies, and chess.
Markdown supported · ⌘↵ to post
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.