depends fully on how you query the data out.
If your going to be using only one field at a time, make seperate indexes.
If your going to be ALWAYS using all 3 fields, then I don't see how a single
combined index would be a problem.
----- Original Message -----
From: "Mike<mickalo>Blezien" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 10:35 AM
Subject: Multiple Column list index
> 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
>
>
>
---------------------------------------------------------------------
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
