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,
>
> 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
