Hello all,
I have a table that stores business locations, which contains 'city','state' and
'zip' and this table is utilize for search queries. Which type of indicing take
full advantage of the MySQL optimizer, create a multiple column index
(city,state,zip) or separate indices on each column.
"M" == MikemickaloBlezien [EMAIL PROTECTED] writes:
M I have a table that stores business locations, which contains
M 'city','state' and 'zip' and this table is utilize for search
M queries. Which type of indicing take full advantage of the MySQL
M optimizer, create a multiple column index
ot; [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 27, 2001 10:35 AM
Subject: Multiple Column list index
Hello all,
I have a table that stores business locations, which contains
'city','state' and
'zip' and this table is utilize for search queries. Which type of indicing