What's wrong with this SQL OR killing the index?

What's wrong with this SQL OR killing the index on a search. The SQL code uses OR on two indexed columns. In MySQL OR often prevents index usage. In SQL APIs one OR turns a millisecond query into seconds.

#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlor #sqlindex #sq...

https://www.youtube.com/watch?v=QeUScSkvDfg

Whats wrong with this SQL OR killing the index? #sqlcodereview

YouTube