question about indexing
Posted: Fri Apr 23, 2010 6:07 pm
I am writing an application that will have search page. The page has firstname, secondname, lastname and lastname2 as separate fields instead of just one name search field. How should I index the table
option1:
KEY `person_fullname` USING BTREE (`firstname`,`secondname`,`lastname`,`lastname2`)
option2:
KEY `firstname` (`firstname`),
KEY `secondname` (`secondname`),
KEY `lastname` (`lastname`),
KEY `lastname2` (`lastname2`)
Is there a difference?
Thank you
option1:
KEY `person_fullname` USING BTREE (`firstname`,`secondname`,`lastname`,`lastname2`)
option2:
KEY `firstname` (`firstname`),
KEY `secondname` (`secondname`),
KEY `lastname` (`lastname`),
KEY `lastname2` (`lastname2`)
Is there a difference?
Thank you