Single Column Indexes Vs. Multi Column

[Michael Stearne]

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 archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]