Re: Best Index Strategy

[Devrishi Shandilya]

Thanks Rick for your help, here are some things :

1- We can not convert soas.telephone = '7600639533' like this, because we are storing country code in this field as well i.e. for India (917600639533)
2- We are not storing year in field cc_exp_year now. it has only 2 distinct values 0 and NULL.
3- cc_last4 columns has no data now, having only NULL values.
4- We are working on data type optimization and remove low cardinality indexes if possiable.

Please suggest how to improve query 1 performance with regards to point 1.


5- Innodb Buffer pool size is 40 GB and RAM of server is 64 GB.

Query 2 has some performance boost by adding index soas.(`address_type`, `telephone`). apart from that your query is giving same result for query 2.