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: "MikeBlezien" <[EMAIL PROTEC
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
