trace the query, see what is going on - make sure your stats are up to date