"mac_man2008@yahoo.it" <mac_man2008@yahoo.it> wrote:
> So, invoking or not invoking sorting depends on different
> parameters of the specific DBMS, does it?
In the right circumstances (where autovacuum or other maintenance
jobs happen to run in the background at the right moment), two
back-to-back runs on the same database with no data or configuration
changes could do this differently. You wouldn't see that too often,
but if the estimated costs of sorting versus non-sorting plans were
close, the random sampling of one statistics sampling run versus
another could cause a change.
-Kevin