select zlxmjc,zlxmbh,SFJE00,wbsm00,zlxmid,pysm00,YBLBMC,ZFBL00,COLOUR from VW_YJ_FBFYYZ_DJBZ where (pysm00 Like '%%' or ZLXMBH Like '%%')
 and ( SFBZDJ=SF_XT_GETSFDJBYBMBH(37)and ((ybbrlb='0' and ybzxlb='0' and fbbh00='1' and sfsfxm='Y') or (sfsfxm='N'))  and MZZYBZ<>'1' )  and Rownum<=30

以上语句花费时间0.89s


去除按分院收费等级判断  ( SFBZDJ=SF_XT_GETSFDJBYBMBH(37)and ）  之后，查询花费时间为0.125s


select zlxmjc,zlxmbh,SFJE00,wbsm00,zlxmid,pysm00,YBLBMC,ZFBL00,COLOUR from VW_YJ_FBFYYZ_DJBZ where (pysm00 Like '%%' or ZLXMBH Like '%%')
 and (  ((ybbrlb='0' and ybzxlb='0' and fbbh00='1' and sfsfxm='Y') or (sfsfxm='N'))  and MZZYBZ<>'1' )  and Rownum<=30