sql条件中比较性能优化

SELECT *
  FROM Sm_Affix t
 WHERE t.Record_Id = 865904162
   AND (t.Table_Code = ‘SV_RETURN_BILL‘ OR
       (SELECT COUNT(*)
           FROM Ad_Lov_Code_v t
          WHERE t.List_Code = ‘SM_AFFIX‘
            AND t.Lov_Code = ‘TABLECODE‘
            AND t.Lov_Name = ‘0‘) = 1);
 

SELECT *
  FROM Sm_Affix t
 WHERE t.Record_Id = 865904162
   AND (t.Table_Code = ‘SV_RETURN_BILL‘ OR
       (SELECT t.Lov_Name
           FROM Ad_Lov_Code_v t
          WHERE t.List_Code = ‘SM_AFFIX‘
            AND t.Lov_Code = ‘TABLECODE‘) = ‘0‘);