Re: long running, can't get to use index
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!
Subject
Views
Written By
Posted
1175
March 24, 2017 10:10AM
683
March 24, 2017 10:32AM
643
March 24, 2017 10:41AM
612
March 27, 2017 10:39AM
679
March 27, 2017 02:04AM
730
April 03, 2017 10:34AM
652
April 03, 2017 12:08PM
Re: long running, can't get to use index
606
May 06, 2017 07:36PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.