On Tue, 27 Feb 2001 12:39:31 -0700, Steve Ruby <[EMAIL PROTECTED]>
wrote:
thanks Steve, this helps. I think I have a better picture now how to set up the
index for the table.
appreciate the info :)
Mickalo
>>Depends on the situation.. Mysql will use only one index per table per query.
>>
>>so if you very often query on all three you should put them in a multi-column
>>index.. If you also often search on only one of the three you should put
>>it first.. If you often search on another one of the three you should consider
>>putting it in a different index... basicaly it depends on the nature
>>of your queries, and how much diskspace/time you are willing to give you index
>>updates and storage.
>>
>>
>>"MikeBlezien" wrote:
>>>
>>> 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,
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