Hi,

> I have a field that can be either a bigint or a string. It will hold a
> UPC bar code. This field will be a primary key for the table. Is there
> any performance penalty for joining on a string field vs a bigint?

UPC = 12 digits ?

Then the performance difference will be minimal, because indices uses
prefix-compression. For most keys only a part of the key is stored in the
index-page.


Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://80.126.130.81