screen link : https://app.dataquest.io/m/116/introduction-to-indexing/3/explain-query-plan
Why do we use “explain query plan”?
what is the use of it?
is it useful for something?
1 Like
-
To see the effects of indexes, whether they speed up queries as intended, or need to be added/improved: https://www.startdataengineering.com/post/what-does-it-mean-for-a-column-to-be-indexed/
-
To see how (loop/hash/merge) joins are executed: https://www.linkedin.com/pulse/loop-hash-merge-join-types-eitan-blumin/
1 Like