I have a table which will be searched via some of the fields in the
column.
An example of the list of searcheable columns:
make
model
body_color
tire_type
hub_caps_type
The thing is that people might do a search using one or many of the
fields as criteria.
For example someone might search for :
body_color = 1 AND tire_type = 11
or just
model = 22
I read that MySQL only uses one index when it performs a query. I
did an EXPLAIN and it appears that only one of the indices is used.
What is the proper way to setup indices in this case?
Shoud I add an Index for each of these fields OR create a multicolumn
index using all of these fields?
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
