SQL—在这里执行子查询或扩展WHERE子句更好吗?

下面的CUST表将与~10个表连接。

特别是对于这个子查询,我是否最好直接连接Customer表并将子查询的4部分WHERE子句移动到主查询的WHERE子句?

select * From 
(select CKey, CID, CName from MainDB.dbo.Customer 
     where 
        LOC = 'ARK' 
        and Status = 1 
        and CID not like 'KAN%' 
        and CID not like 'MIS%') as CUST