Why does the sort order change...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

This is not a particular problem, I'm just curious to know what determines
the secondary sort when I have a query sorted just on a single date field if
there are multiple records for the same date. Record order seems to change
from day to day and I can't figure out why.....thanks for any answers
Sheila
 
The order of records is essentially random unless you've got an appropriate
sort defined.

Tables are "buckets" of data: you should never make any assumptions about
the physical order of records in them, since that order can be changed by
doing updates to the table, and by compacting.
 
Back
Top