10, 2008 6:57 AM
Subject: Re: Single Column Indexes Vs. Multi Column
Michael Stearne schrieb:
For a query like:
SELECT id FROM properties WHERE `Country` = 'USA' AND
Type='Residential'
Is an multi-column index that is (Country, Type) better or worse or the
same as a single index Country
C.R.Vegelin wrote:
Sebastian,
MySQL uses only one index for searching.
As far as I know this applies to all MySQL versions, right ?
AFAIK, MySQL (atleast from version 5.0 onwards) is capable of
using multiple indexes.
--
Regards,
Anup Shukla
--
MySQL General Mailing List
For list archives:
C.R.Vegelin schrieb:
Sebastian,
MySQL uses only one index for searching.
As far as I know this applies to all MySQL versions, right ?
IMHO, but i heard elselike too, but cannot find any proof in the manual ...
--
Sebastian
--
MySQL General Mailing List
For list archives:
Anup Shukla schrieb:
C.R.Vegelin wrote:
Sebastian,
MySQL uses only one index for searching.
As far as I know this applies to all MySQL versions, right ?
AFAIK, MySQL (atleast from version 5.0 onwards) is capable of
using multiple indexes.
i have heard of something similar too, but cannot
Perrin Harkins schrieb:
On Jan 11, 2008 7:22 AM, Sebastian Mendel [EMAIL PROTECTED] wrote:
i can only find one source in the manual, where MySQL is using more than on
index:
http://dev.mysql.com/doc/refman/6.0/en/index-merge-optimization.html
Uh, how many sources do you need?
1?
It
On Jan 11, 2008 7:22 AM, Sebastian Mendel [EMAIL PROTECTED] wrote:
i can only find one source in the manual, where MySQL is using more than on
index:
http://dev.mysql.com/doc/refman/6.0/en/index-merge-optimization.html
Uh, how many sources do you need? It uses multiple indexes, just like
it
Sebastian Mendel schrieb:
Anup Shukla schrieb:
C.R.Vegelin wrote:
Sebastian,
MySQL uses only one index for searching.
As far as I know this applies to all MySQL versions, right ?
AFAIK, MySQL (atleast from version 5.0 onwards) is capable of
using multiple indexes.
i have heard of
For a query like:
SELECT id FROM properties WHERE `Country` = 'USA' AND
Type='Residential'
Is an multi-column index that is (Country, Type) better or worse or
the same as a single index Country and another single index Type.
Thanks,
Michael
--
MySQL General Mailing List
For list
Michael Stearne schrieb:
For a query like:
SELECT id FROM properties WHERE `Country` = 'USA' AND Type='Residential'
Is an multi-column index that is (Country, Type) better or worse or the
same as a single index Country and another single index Type.
better
two single indexes depending on