Re: Re: [firebird-support] AW: Performance comparision for primary keys - int vs. varchar

Dear Ann, thank you very much for the detailed reply. Regards Martin

Re: [firebird-support] AW: Performance comparision for primary keys - int vs. varchar

On Fri, Oct 2, 2015 at 5:09 PM, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > > > I’m using integer IDs for primary keys in my tables. What if I would use > varchar fields instead? Will I lose performance in that case, especially > for big

Re: [firebird-support] AW: Performance comparision for primary keys - int vs. varchar

Guten Tag ""Köditz, on another list if have read the following comment on a similar question integers are compared as integers, one operation strings are compared on a per characters basis so changing your integer into a length 10 string would mean 10 comparisons instead of

Re: [firebird-support] AW: Performance comparision for primary keys - int vs. varchar

At 10:09 a.m. 3/10/2015, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > >I’m using integer IDs for primary keys in my tables. What if I would use >varchar fields instead? Will I lose performance in that case, especially for >big tables? Will joins still work as fast as

[firebird-support] AW: Performance comparision for primary keys - int vs. varchar

Hi, I'm using integer IDs for primary keys in my tables. What if I would use varchar fields instead? Will I lose performance in that case, especially for big tables? Will joins still work as fast as they do for the integer column. In my case I have a table TBL_BANK ( BANK_ID int, BIC