ConceptSystems & CS
Uncorrelated Subquery
A subquery that does not reference any attributes from the outer query, allowing the DBMS to logically execute it once and reuse the result.
Know first
Named as a prerequisite by the lectures that define this. The number is how many say so. A grey one has no page yet.
Subqueries2SQL select queries1SQL SELECT statements1
Opens up
Concepts that name this one as a prerequisite.
Lecturers
1Andy Pavlo
Connections
3The lectures that define it or assume it, and the concepts next to it.