Judging by some of the comments posed on this list, I wonder whether the following statements are true: 1. There is no point having an index on a field if that field can only have a few values 2. A table should have at least ten entries, in order to prevent all the table being scanned to find a match in a query. Does this mean that one should pad out a table (ie add spurious values with an 'ignore' flag) in order to force mySQL to use an index?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]