Sebastian,
MySQL uses only one index for searching.
As far as I know this applies to all MySQL versions, right ?
Regards, Cor
----- Original Message -----
From: "Sebastian Mendel" <[EMAIL PROTECTED]>
To: "Michael Stearne" <[EMAIL PROTECTED]>; "MySQL List"
<mysql@lists.mysql.com>
Sent: Thursday, January 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 and another single index Type.
better
two single indexes depending on your MySQL version will not be used.
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
