[AccessD] Question about the TableDef.Fields collection

[Stuart McLachlan]

On 26 Aug 2022 at 12:58, John Colby wrote:

> Autonumbers serve another purpose, speeding up joins.  Joining strings
> between tables requires a visit to a library where the string is
> scanned and compared to the other field byte by byte.  A long integer
> OTOH used a simple equal operator on a 32 bit number.  One instruction
> vs potentially hundreds.
> 

This!

Don't conflate Primary Keys with Unique indexes, they serve different purposes.
You can  impose constraints on a field or a group of fields with unique indexes. Keys are 
designed to uniquely identify a row for edit/delete operations and there use optimises joins.