Most databases that aren't postgres have some sort of query hinting.