SELECT FTYPENAME, FPRIORITY, FSUBJECT, FFLOWGUID, FBizID, FSPERSON, FSPERSONNAME, FRPERSONNAMES, FSTARTTIME, FFINISHTIME, FLIMITTIME, FWARNINGTIME, FPARTYNAME, FPLAN, FPROJECTNAME, FPROJECT, FSOGNNAME, FSDEPTNAME, FSPOSITIONNAME, FSTATE, FLASTCHANGETIME, FCREATETIME, FPLANSTARTTIME, FPLANFINISHTIME, FDISTRIBUTETIME, TTASK.FPARTY, FGUID, FTYPE, FFUNCURL, FUPDATEFLAG, FPROCURL, FDESCRIPTION, FISANONYMITY
FROM TTASK
WHERE (FGROUPGUID = '-1' AND (FKIND in ('ftkActivity', 'ftkReturn', 'ftkTransmit', 'ftkNotify', 'ftkGroup', '', 'ftkHasten') or FKIND is null)) AND (((TTASK.FCLIENTACCOUNT = 'JUSTEP.COM')) and ((TTask.FCREATETIME >= '2010-04-05 00:00:00') AND (TTask.FCREATETIME <= '2010-04-11 23:59:59') AND (FGUID IN(SELECT TTASKMESSAGE.FTASKGUID FROM TTASKMESSAGE WHERE TTASKMESSAGE.FRORGURL IN('\ROOT\KCJSZX.OGN\DKCPS.DPT\SZ.PTM\YANGSHAOHUA.PSM') OR ((TTASKMESSAGE.FRDEPT = 'DKCPS') AND (TTASKMESSAGE.FRPOSITION = 'SZ') AND (TTASKMESSAGE.FRPERSON = 'YANGSHAOHUA')) OR ((TTASKMESSAGE.FRORGURL LIKE '\ROOT\KCJSZX.OGN\DKCPS.DPT%')) AND (NOT (TTask.FTYPE IN ('CHIEFMEETINGREC', 'CHIEFMEETINGRECDEAL', 'NEWSPLACARD'))) UNION SELECT T1.FGUID FROM TTASK T1 WHERE T1.FSORGURL IN('\ROOT\KCJSZX.OGN\DKCPS.DPT\SZ.PTM\YANGSHAOHUA.PSM') OR ((T1.FSDEPT = 'DKCPS') AND (T1.FSPOSITION = 'SZ') AND (T1.FSPERSON = 'YANGSHAOHUA')) OR ((T1.FSORGURL LIKE '\ROOT\KCJSZX.OGN\DKCPS.DPT%')) AND (NOT (T1.FTYPE IN ('CHIEFMEETINGREC', 'CHIEFMEETINGRECDEAL', 'NEWSPLACARD'))))) AND (FTYPE IS NULL OR FTYPE NOT IN ('TASKREMIND'))))
ORDER BY FCREATETIME DESC
把上面的sql放到查询分析器中执行一下看看需要多久？ |
楼主
发表于 2010-4-9 16:54:41