SQL 查询语句 超时已过期,如何优化????????????
SELECT FinDT, RoadNetID, RoadID, SubRoadID, StationID, CheckStation, InRoadNetID,  
       InRoadID, InSubRoadID, InStationID,
           (SELECT COUNT(*)
          FROM TC_OutList
          WHERE IsTruck = 1 AND Weight <= LimitLoad AND A.FinDT = FinDT AND  
                A.StationID = StationID AND A.RoadNetID = RoadNetID AND  
                RoadID = A.RoadID AND A.SubRoadID = SubRoadID AND  
                A.CheckStation = CheckStation AND A.InRoadNetID = InRoadNetID AND  
                A.InSubRoadID = InSubRoadID AND InStationID = A.InStationID)  
       AS OvTruCnt0,
           (SELECT COUNT(*)
          FROM TC_OutList
          WHERE IsTruck = 1 AND Weight > LimitLoad AND Weight <= LimitLoad * 1.3 AND  
                A.FinDT = FinDT AND A.StationID = StationID AND  
                A.RoadNetID = RoadNetID AND RoadID = A.RoadID AND  
                A.SubRoadID = SubRoadID AND A.CheckStation = CheckStation AND  
                A.InRoadNetID = InRoadNetID AND A.InSubRoadID = InSubRoadID AND  
                InStationID = A.InStationID) AS OvTruCnt1,
           (SELECT COUNT(*)
          FROM TC_OutList
          WHERE IsTruck = 1 AND Weight > LimitLoad * 1.3 AND  
                Weight <= LimitLoad * 1.5 AND A.FinDT = FinDT AND  
                A.StationID = StationID AND A.RoadNetID = RoadNetID AND  
                RoadID = A.RoadID AND A.SubRoadID = SubRoadID AND  
                A.CheckStation = CheckStation AND A.InRoadNetID = InRoadNetID AND  
                A.InSubRoadID = InSubRoadID AND InStationID = A.InStationID)  
       AS OvTruCnt2,
           (SELECT COUNT(*)
          FROM TC_OutList
          WHERE IsTruck = 1 AND Weight > LimitLoad * 1.5 AND  
                Weight <= LimitLoad * 2 AND A.FinDT = FinDT AND  
                A.StationID = StationID AND A.RoadNetID = RoadNetID AND  
                RoadID = A.RoadID AND A.SubRoadID = SubRoadID AND  
                A.CheckStation = CheckStation AND A.InRoadNetID = InRoadNetID AND  
                A.InSubRoadID = InSubRoadID AND InStationID = A.InStationID)  
       AS OvTruCnt3,
           (SELECT COUNT(*)
          FROM TC_OutList
          WHERE IsTruck = 1 AND Weight > LimitLoad * 2 AND A.FinDT = FinDT AND  
                A.StationID = StationID AND A.RoadNetID = RoadNetID AND  
                RoadID = A.RoadID AND A.SubRoadID = SubRoadID AND  
                A.CheckStation = CheckStation AND A.InRoadNetID = InRoadNetID AND  
                A.InSubRoadID = InSubRoadID AND InStationID = A.InStationID)  
       AS OvTruCnt4,
           (SELECT SUM(PayMoney)
          FROM TC_OutList
          WHERE IsTruck = 1 AND Weight <= LimitLoad AND A.FinDT = FinDT AND  
                A.StationID = StationID AND A.RoadNetID = RoadNetID AND  
                RoadID = A.RoadID AND A.SubRoadID = SubRoadID AND  
                A.CheckStation = CheckStation AND A.InRoadNetID = InRoadNetID AND  
                A.InSubRoadID = InSubRoadID AND InStationID = A.InStationID)  
       AS OvTruMny0,
           (SELECT SUM(PayMoney)
          FROM TC_OutList
          WHERE IsTruck = 1 AND Weight > LimitLoad AND Weight <= LimitLoad * 1.3 AND  
                A.FinDT = FinDT AND A.St