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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
