向高手请教这条SQL可否优化？

[rickzeng]

向高手请教这条SQL可否优化？
请看下面:..........

WITH CarPartsCTE AS (SELECT   物料编号, 用量
                                     FROM      B_物料清单
                                     WHERE   (产品编号 = N'1001001-1000')
                                     UNION ALL
                                     SELECT   B_物料清单_1.物料编号, CarPartsCTE_2.用量 * B_物料清单_1.用量 AS Expr1
                                     FROM      CarPartsCTE AS CarPartsCTE_2 INNER JOIN
                                                     B_物料清单 AS B_物料清单_1 ON CarPartsCTE_2.物料编号 = B_物料清单_1.产品编号)
    SELECT   产品编号, 部门编号, 分钟
    FROM      (SELECT   TOP (100) PERCENT N'1#1001001-1000' AS 产品编号, B_加工中心.部门编号, SUM(B_加工流程.合计分钟) 
                                     * 480 AS 分钟
                     FROM      B_加工中心 INNER JOIN
                                     B_加工流程 ON B_加工中心.加工编号 = B_加工流程.加工编号 INNER JOIN
                                         (SELECT   TOP (1) 产品编号, 1 AS 用量
                                          FROM      B_物料清单 AS B_物料清单_2
                                          WHERE   (产品编号 = N'1001001-1000')
                                          UNION ALL
                                          SELECT   物料编号, SUM(用量) AS 单耗
                                          FROM      CarPartsCTE AS CarPartsCTE_1
                                          WHERE   (NOT EXISTS
                                                              (SELECT   1 AS Expr1
                                                               FROM      A_物料 AS A_物料_1
                                                               WHERE   (物料编号 = CarPartsCTE_1.物料编号)))
                                          GROUP BY 物料编号) AS tb ON B_加工流程.产品编号 = tb.产品编号
                     GROUP BY B_加工中心.部门编号
                     ORDER BY B_加工中心.部门编号) AS tb2
    WHERE   (NOT (产品编号 IN
                        (SELECT   CONVERT(nvarchar, 销售订单编号) + N'#' + 产品编号 AS Expr1
                         FROM      PO_部门排产)))

[水哥阿乐]

发SQL版块内吧

[古今多少事]

够长的，不知道要查什么。