[AccessD] Sort Order of a Table

...I sort the table contents based upon the way the data will be most 
frequently used ...I also set indexes on those fields on which 
sorts/searches are likely to be based ...that way a query based upon it 
doesn't have to reindex the data before passing it on ...a tblCompany is 
going to be sorted by the CompanyName ...a tblContacts by the LastName 
...how much of a difference in time it makes I don't know but it sure 
simplifies my life in using the contents.

William

----- Original Message ----- 
From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Monday, December 24, 2007 12:48 PM
Subject: [AccessD] Sort Order of a Table


> Dear List:
>
> Sometimes when I'm looking at a table I'll resort it by one column or
> another.  Mostly they're sorted by the Autonumber ID.  When I go to close
> it, I'm asked if I want to save changes.  Mostly I say no.
>
> So question: is there a difference in the table or in the way data is
> retrieved and/or most importantly in retrieval time, depending on how the
> records are displayed - sorted by primary key or another field?  Can I 
> just
> leave the table sorted by, say name or address or social security number
> without a performance penalty?
>
> MTIA
>
> Rocky
>
>
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com