Home Index is not being considered in mysql
Reply: 0

Index is not being considered in mysql

Passionate
1#
Passionate Published in 2018-01-12 23:41:59Z

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.304846 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO