Hi all

Which of these two tables wiil yield the best performance in a table
with about 6 million entries (for rapid selects on either field):

table_using_char
field1 char(50),
field2 char(50),
filed 3 char(50),
separate unique indexes on all 3 fields


table_using_varchar
field1 varchar(50),
field2 varchar(50),
field3 varchar(50),
separate unique indexes on all 3 fields

My gut feeling is the char table should be faster since each record will
then be an exact length, but does this reasoning apply since I will be
indexing each field and they are also unique (so any one select will
only ever return exactly 1 or 0 results)?

Thanks
Alec