MySQL Forums
Forum List  »  Performance

Re: Best Index Strategy
Posted by: Devrishi Shandilya
Date: August 10, 2015 11:30PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
2043
August 09, 2015 11:35PM
814
August 10, 2015 07:02AM
765
August 10, 2015 07:17AM
Re: Best Index Strategy
743
August 10, 2015 11:30PM
741
August 12, 2015 10:53PM
712
August 15, 2015 04:34PM
717
August 16, 2015 11:53PM


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.