An SQL query contains a WHERE clause with multiple conjunctive selection…
GPSC College Teaching (CS/IT) 2025
An SQL query contains a WHERE clause with multiple conjunctive selection conditions (e.g., WHERE A = 'val1' AND B > 100 AND C LIKE 'pattern%'). In query optimization, which relational algebra equivalence rule is primarily applied to potentially improve efficiency by performing selections early?
- A.
(Commutativity of selection)
- B.
(Cascade of selection)
- C.
(Commutativity of projection and selection)
- D.
(Associativity of natural join)
Attempted by 24 students.
Sign up free to check your answer
Sign up freeLoading lesson…

