Home Index is not being considered in mysql
Reply: 0

Index is not being considered in mysql

user497
1#
user497 Published in May 27, 2018, 11:30 pm

I have a problem in deciding on index. I have a table in mySQL say X with atlas 70 million records. I need to query few fields based on filter like Year = X and Quarter = X and ( user = X or manager = X or ..)

I have an index on year and quarter which is not considered. So if it is considered, then less than 10% of the data is used.

I have index on year, quarter and all the user fields. Even then the index is not considered.

What am I doing wrong?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.30762 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO