Cory at SkyVantage wrote:
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
Then a full table scan is faster than using an index for res_status=0.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]