'Optimizing a certain query

I have a query that goes such:

bankNumber and BIC are both indexed.

SELECT * FROM `bank1` WHERE `bankNumber` <= 200000 or `BIC` = 'Berlin'

By using the EXPLAIN, it uses both of the keys in possible_keys. I read in an article that one of the things that not to do when queries for indicies is to use OR.

I am tasked to optimize this query so that only one key gets used in the execution strategy. What should I do in this case?

Things that I've tried:

Obviously went for AND, that did give me the desired result from EXPLAIN, but the data results are completely different.

mysql optimization

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Optimizing a certain query

Sources

Related Questions