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]
