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 ... the changes originate ...