Subject Re: [firebird-support] varchar in indexes
Author Ann W. Harrison
At 05:55 AM 10/19/2004, marcelo.miorelli@... wrote:

>Is there any problem in creating varchar indexes?


>The performance is better when integer indexes are used?

No. Or rather, it depends on the size of the varchar. If
you have an eighty character key with a complex collating
sequence and actually provide eighty character values, that
index will be slower than an index with a four byte integer

>Suppose the country code varchar(2), is it good, bad, or neutral?

Bad. Don't use varchar for character strings less that four characters
long or for fixed length character strings.