an IN subquery where the column in the inner subquery is indexed correlated subqueries, where the column being compared with the correlated reference is indexed join-queries, where the join-expression ...