gerald_clark wrote:
How many possible values may res_status have? What percentage for each value? It may not be possible to use an index on this field.
The res_status field may have up to 10 different values from 0-9. and there will be a huge amounts of '0' and thousands of records with 1-9 (most likely ~70% '0's)
Cory -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]