List:General Discussion« Previous MessageNext Message »
From:Vivek Khera Date:February 27 2001 7:39pm
Subject:Re: Multiple Column list index
View as plain text  
>>>>> "M" == Mike<mickalo>Blezien  <mickalo@stripped>
> 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 <mysql-thread66794@stripped>
M> To unsubscribe, e-mail
> <mysql-unsubscribe-ml-mysql-general=kcilink.com@stripped>
M> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@stripped       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/
Thread
Multiple Column list indexMike<mickalo>Blezien27 Feb
  • Re: Multiple Column list indexSteve Ruby27 Feb
    • Re: Multiple Column list indexMike<mickalo>Blezien27 Feb
  • Re: Multiple Column list indexVivek Khera27 Feb
  • Re: Multiple Column list indexEric Fitzgerald27 Feb