These issues are also why sql hints exist.