Subject | varchar in indexes |
---|---|
Author | marcelo.miorelli@kiddeuk.co.uk |
Post date | 2004-10-19T09:55:05Z |
Hi all,
Is there any problem in creating varchar indexes?
The performance is better when integer indexes are used?
Suppose the country code varchar(2), is it good, bad, or neutral?
(Embedded image moved to file: pic18467.pcx)
________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
[Non-text portions of this message have been removed]
Is there any problem in creating varchar indexes?
The performance is better when integer indexes are used?
Suppose the country code varchar(2), is it good, bad, or neutral?
(Embedded image moved to file: pic18467.pcx)
________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
[Non-text portions of this message have been removed]