首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > SQL Server >

同志们帮忙优化个SQL话语,谢了

2012-08-27 
同志们帮忙优化个SQL语句,急,谢了啊SQL codeSELECTV_APPROVAL_WORK_ITEM.ENTITY_NAME ,V_APPROVAL_WORK_IT

同志们帮忙优化个SQL语句,急,谢了啊

SQL code
SELECT  V_APPROVAL_WORK_ITEM.ENTITY_NAME ,        V_APPROVAL_WORK_ITEM.ENTITY_NO ,        V_APPROVAL_WORK_ITEM.SUMMARY ,        ENTITY_WF_INST.START_DATE ,        V_APPROVAL_WORK_ITEM.ENTITY_ID ,        V_APPROVAL_WORK_ITEM.ENTITY_TYPE ,        V_APPROVAL_WORK_ITEM.FLOW_TYPE,MIN(APPROVAL_NO),MIN(CATE_APPROVAL_NO)FROM    dbo.V_APPROVAL_WORK_ITEM        INNER JOIN dbo.ENTITY_WF_INST ON dbo.V_APPROVAL_WORK_ITEM.ENTITY_TYPE = dbo.ENTITY_WF_INST.ENTITY_TYPE AND dbo.V_APPROVAL_WORK_ITEM.ENTITY_ID = dbo.ENTITY_WF_INST.ENTITY_IDWHERE   CUR_USER_ID = 29        AND APPROVAL_NO IN (        SELECT  MIN(APPROVAL_NO)        FROM    V_APPROVAL_WORK_ITEM a        WHERE   a.Entity_ID = V_APPROVAL_WORK_ITEM.Entity_ID                AND a.Entity_TYPE = V_APPROVAL_WORK_ITEM.ENTITY_TYPE )        AND CATE_APPROVAL_NO IN (        SELECT  MIN(CATE_APPROVAL_NO)        FROM    V_APPROVAL_WORK_ITEM a        WHERE   a.Entity_ID = V_APPROVAL_WORK_ITEM.Entity_ID                AND a.ENTITY_TYPE = V_APPROVAL_WORK_ITEM.ENTITY_TYPE )GROUP BY V_APPROVAL_WORK_ITEM.ENTITY_NAME ,        V_APPROVAL_WORK_ITEM.ENTITY_NO ,        V_APPROVAL_WORK_ITEM.SUMMARY ,        ENTITY_WF_INST.START_DATE ,        V_APPROVAL_WORK_ITEM.ENTITY_ID ,        V_APPROVAL_WORK_ITEM.ENTITY_TYPE ,        V_APPROVAL_WORK_ITEM.FLOW_TYPEORDER BY dbo.ENTITY_WF_INST.START_DATE DESC


[解决办法]
最多把where中子查询改成连接来处理,说不定会快些.

热点排行
Bad Request.