RE: Can't get MySQL to use available memory (performance very slow)

[Kent Hoover]

I believe the answer will be for you to create a single index on *just*
the cust column. (I assume that a specific cust id occurs only once or a
few times in the
whole table.) This will allow MySQL to use that index to find the small
set of records (quickly) where cust=1,
then to screen the email value against that set of records.

Cheers,

Kent
query,database