Re: Do not want data to auto sort
- From: peregenem@xxxxxxxxxxxx
- Date: 4 Aug 2005 02:33:23 -0700
Rick B wrote:
> Tables do not reliably sort data.
The word 'reliably' makes no sense here. A table cannot sort data. A
cursor sorts data.
> Tables are buckets for storing records
What is it with 'buckets around here?! At the physical level, the data
in a table is stored in a high predictable order (PK order as at last
file compact, date/time order subsequently). You are correct in
pointing out a table's physical attributes are not significant
considerations. Tables should only really be considered at the
logically level i.e. a complete set of entities.
> You should not be using the tables as an
> interface anyway
Again, this makes no sense. How can table be an interface?
.
- Follow-Ups:
- Re: Do not want data to auto sort
- From: Rick B
- Re: Do not want data to auto sort
- References:
- Do not want data to auto sort
- From: Rod
- Re: Do not want data to auto sort
- From: Rick B
- Do not want data to auto sort
- Prev by Date: UPDATE and ALTER in transactions do not mix
- Next by Date: Re: UPDATE and ALTER in transactions do not mix
- Previous by thread: Re: Do not want data to auto sort
- Next by thread: Re: Do not want data to auto sort
- Index(es):