4 ms·
Are we talking about IN clauses that contain a correlated subquery or something the optimizer would have a hard time determining was independent of outer contex
by tmoertel 14y ago
Are we talking about IN clauses that contain a correlated subquery or something the optimizer would have a hard time determining was independent of outer context?
- jeltz 14y agoPostgreSQL is able to convert correlated subqueries with IN () clauses into joins in most cases. My guess is that it could have been two queries refactored into one.