在超过100万行的表中效率更高？交叉加入或子查询？

I need to create a view that will filter a date range that is set in only 1 row in an auxiliary table:I need to create a view that will filter a date