查询中引用外库会影响效率吗比如
SELECT MENUCODE, MENUNAME, FATHERMENU, ISMENU, WINDOWNAME
FROM SystemInfo..Info_MenuInfo WHERE VESTSYSTEM = 'LOANWEB' and ISVISIBLE = 1
AND ISMENU = 1 and MENUCODE IN (SELECT MENUCODE FROM SystemInfo..Info_MenuStaff
WHERE VESTSYSTEM = 'LOANWEB' and HR_NO = @HR_No)
SELECT MENUCODE, MENUNAME, FATHERMENU, ISMENU, WINDOWNAME
FROM SystemInfo..Info_MenuInfo WHERE VESTSYSTEM = 'LOANWEB' and ISVISIBLE = 1
AND ISMENU = 1 and MENUCODE IN (SELECT MENUCODE FROM SystemInfo..Info_MenuStaff
WHERE VESTSYSTEM = 'LOANWEB' and HR_NO = @HR_No)
SELECT MENUCODE, MENUNAME, FATHERMENU, ISMENU, WINDOWNAME
FROM SystemInfo..Info_MenuInfo t1
WHERE VESTSYSTEM = 'LOANWEB' and ISVISIBLE = 1
AND ISMENU = 1 and exists(SELECT top 1 FROM SystemInfo..Info_MenuStaff
WHERE MENUCODE=t1.MENUCODE and VESTSYSTEM = 'LOANWEB' and HR_NO = @HR_No)