to be more generic, I'd say that it depends on your optimizer mode, on the freshness of the stats, and on the indexes ...