Subject Re: [firebird-support] Performance Penalty for String Joins?
Author Arno Brinkman

> 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

Arno Brinkman

Firebird open source database (based on IB-OE) with many SQL-99 features :

Support list for Interbase and Firebird users :

Nederlandse firebird nieuwsgroep :