What is the use of explain query plan

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
  1. 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/

  2. To see how (loop/hash/merge) joins are executed: https://www.linkedin.com/pulse/loop-hash-merge-join-types-eitan-blumin/

1 Like