>>>>> "M" == Mike<mickalo>Blezien <[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 (city,state,zip) or
M> separate indices on each column.
The use of indexes depends on your queries. What do your queries look
like? There's no point building an index unless your queries can take
advantage of it.
M> ---------------------------------------------------------------------
M> Before posting, please check:
M> http://www.mysql.com/manual.php (the manual)
M> http://lists.mysql.com/ (the list archive)
M> To request this thread, e-mail <[EMAIL PROTECTED]>
M> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
M> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
---------------------------------------------------------------------
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
