in a select statement, is the order of elements in the where clause the determining factor on what records are chosen first, second etc?
for instance... select fname from maintable where status=1 and dob > '2001-03-10'; does that mean that the records will first be checked for status creating a pool of records with status=1 to then check for dob out of that pool or if one of the fields is an index will it automatically use the index first or does it use some other ordering methodology? TIA Larry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
