优化使用“不为空”的左连接查询

I've struggled with this one for a long time. This query runs fairly fast on a smaller data set but when the tables grow to 100k+ rows it takes from 30s to several minutes to run:I've struggled with this one for a long time. T