哪位大侠能帮我优化一下下面的sql
SELECT COUNT(*) FROM D_FILE12 WHERE ( PRJCODE||' '||KEYWORD||' '||TITLE||' '||GCMC||' '||TUM||' '||ZGCS||' '||SZGS||' '||ZUZ||' '||ZSJR||' '||ZRZG||' '||JH||' '||SJZT||' '||CAD||' '||BL||' '||VFZR||' '||JDRQ||' '||F1||' '||SPMC||' '||LSBH||' '||SJJD||' '||SSJH||' '||ND like '%1%' escape '\' ANDATTR IN (0,1)AND (((1=0) OR (DEPTSYS='8a76839c34cfb22101354134b2b70cf0' OR 1=0)) OR ( ( 1=1AND (MJ<='1_公开' OR MJ IS NULL))OR ( DEPTSYS ='8a76839c34cfb22101354134b2b70cf0'AND (MJ<='1_公开' OR MJ IS NULL)) )OR (1=0) ) AND STATUS = 0 AND UNITSYS = '0001' )
页:
[1]