Explain plans
When we write SQL and want to execute it, what happens behind the scene is that query optimizer creates steps to execute your query against the database. Basically, the optimizer's job is to take SQL statements and decide how to fetch the data in the quickest manner.
Kristijan R. — 7 min reading