The query optimizer has to figure out by itself what indexes to use to avoid brute ... I’ll explain this by using examples in DDL, using SQL Server syntax. The short version of this is fairly ...

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 ... indexes for all ...