so this depends on the database engine and while in general it may follow a pattern there are no guarantees. To dig deeper: https://en.wikipedia.org/wiki/Quer

so this depends on the database engine and while in general it may follow a pattern there are no guarantees. To dig deeper: https://en.wikipedia.org/wiki/Query_plan https://en.wikipedia.org/wiki/Query_plan https://www.khanacademy.org/computing/computer-programming/sql/relational-queries-in-sql/a/more-efficient-sql-with-query-planning-and-optimization https://www.khanacademy.org/computing/computer-programming/s... so, SQL is not about how you're going to get the results it's about what results you want.