At 05:55 AM 10/19/2004, marcelo.miorelli@... wrote:

>Is there any problem in creating varchar indexes?

No.

>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
key.

>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.


Regards,


Ann