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.
Thanks,
Mickalo
Mike(mickalo)Blezien
========================================
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=========================================
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php