Hi,

We are putting together a database which will utilise 22 character UIDs as the primary key on most tables. Has anyone done any tests to see if there is a significant performance penalty for using varchar as the datatype for the primary and foreign keys rather than char?

The data will be stored in Orcacle of MS SQL Server databases rather than VFP tables.

TIA