4 ms·Free e-Book for Index Based SQL Tuning 23 points by muriithi 16y agojulius_geezer 16y agoOr sometimes don't. For sufficiently large joins, a hash join that ignores indexes can save you and a nested loop on the index kill you.