What's wrong with this SQL COALESCE preventing index use?

What's wrong with this SQL COALESCE preventing index use. The SQL code filters with COALESCE(column, default). In MySQL functions on columns block indexes. In SQL the query scans the whole table.

#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlcoalesce #sqlind...

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