Re: long running, can't get to use index

[Benoit St-Jean]

Hi Eric,

A few questions.

1) Can you post the EXPLAIN for this query
2) Do you always have 2 r_userid in your query or it could be more/less (i.e. "r_userid IN ( 1, 200 )"
3) I noticed that r_type is a string. Could you use an INT instead?
4) Have you tried partitionning?
Before re-designing your tables, show us the EXPLAIN. I'm pretty sure there's a way to make this fast!
5) Can you provide numbers on selectivity for r_userid, r_status and r_type?

SELECT COUNT(DISTINCT columnname) AS distinctvalues
FROM yourtablename



Thank you!