sql

more

What is the efficiency of a query + subquery that finds the minimum parameter of a table in SQL?

I’m currently taking an SQL course and trying to understand efficiency of queries. Given this query, what’s the efficiency of it: SELECT * FROM Customers WHERE Age = (SELECT MIN(Age) FROM Customers) What i’m trying to understand is if the subquery runs once at the beginning and then the query is O(n+n)? Or does the […]

Read More