Hello!
When discussing performance issues on inner-join-queries, people tend to advise using a subquery like “SELECT id FROM table WHERE value IN (SELECT something FROM othertable WHERE original_condition)”.
As this strategy did not work for me at all, I kept looking for some solution and came across an article which can be found at http://www.artfulsoftware.com/infotree/queries.php#568
Now my question would be, whether “IN (subquery)” is ever fit to optimize a query, and if so, how?
Tobias