n" <[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 ta
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
> "M" == MikeBlezien <[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
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 shou
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.
T
