sql = "SELECT "
sql = sql + " rownumber() over (order by tb0.LAST_UPD_TIME DESC) as row_number,"
sql = sql + " tb0.MQi_No, "
sql = sql + " tb0.MQI_CREATE_DATE, "
sql = sql + " tb1.Dealer_Name as DealerName, "
sql = sql + " tb2.User_Name as CREATE_USER_Name , "
sql = sql + " tb0.LAST_UPD_TIME, "
sql = sql + " tb0.reporter, "
sql = sql + " subject, "
sql = sql + " tb3.PARTNO, "
sql = sql + "tb4.CPARTNAME "
sql = sql + " FROM gtech.T_MQI_REPORT as tb0 "
sql = sql + " left outer join gtech.M_Dealer as tb1 on tb0.DEALER_CD =tb1.DEALER_CD "
sql = sql + " left outer join gtech.M_User as tb2 on tb0.MQI_CREATOR_CD =tb2.User_CD "
sql = sql + " left outer join gtech.T_PARTS as tb3 on tb0.MQI_NO = tb3.REPNO AND tb3.PART_TYPE = 'M' "
sql = sql + " left outer join gtech.M_part_library as tb4 on tb3.PARTNO=tb4.PARTSNO"
我将如何创建索引呢,查的太慢要40多s是单个单个字段的创建还是创建一个包括所有的 求救!
ps:我不太了解索引,db2的数据库
sql = sql + " rownumber() over (order by tb0.LAST_UPD_TIME DESC) as row_number,"
sql = sql + " tb0.MQi_No, "
sql = sql + " tb0.MQI_CREATE_DATE, "
sql = sql + " tb1.Dealer_Name as DealerName, "
sql = sql + " tb2.User_Name as CREATE_USER_Name , "
sql = sql + " tb0.LAST_UPD_TIME, "
sql = sql + " tb0.reporter, "
sql = sql + " subject, "
sql = sql + " tb3.PARTNO, "
sql = sql + "tb4.CPARTNAME "
sql = sql + " FROM gtech.T_MQI_REPORT as tb0 "
sql = sql + " left outer join gtech.M_Dealer as tb1 on tb0.DEALER_CD =tb1.DEALER_CD "
sql = sql + " left outer join gtech.M_User as tb2 on tb0.MQI_CREATOR_CD =tb2.User_CD "
sql = sql + " left outer join gtech.T_PARTS as tb3 on tb0.MQI_NO = tb3.REPNO AND tb3.PART_TYPE = 'M' "
sql = sql + " left outer join gtech.M_part_library as tb4 on tb3.PARTNO=tb4.PARTSNO"
我将如何创建索引呢,查的太慢要40多s是单个单个字段的创建还是创建一个包括所有的 求救!
ps:我不太了解索引,db2的数据库
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货