SQL优化问题

看见一段代码，一同事写的，功能实现了，可是有很别扭和很不好的地方，看看你能不能找出来昂：

 

SELECT A.PRODUCT_CODE,
       A.S_UUID,
       A.MARKET_CODE,
       A.TRADE_CODE,
       A.STOCK_PROPERTY,
       A.SPLIT_TYPE_CODE,
       A.PROPERTY_TYPE,
       A.PROPERTY_VALUE,
       A.SPLIT_PER_VALUE,
       A.SCOPE_BASE,
       A.OFFSET_DAYS,
       T.PRODUCT_SHORT_NAME PRODUCT_SHORT_NAME,
       decode(A.MARKET_CODE,'00','全部市场',K.KIND_NAME) AS MARKET_NAME,
       decode(A.TRADE_CODE,'00','全部交易方式',K2.KIND_NAME) AS TRADE_TYPE_NAME,
       decode(A.STOCK_PROPERTY,'00','全部品种分类',K3.KIND_NAME)  AS STOCK_NAME,
       K4.KIND_NAME AS SPLIT_TYPE,
       K5.KIND_NAME AS PROPERTY_TYPE_VALUE,
       K6.KIND_NAME AS SPLIT_BASE_VALUE
FROM SPLIT_CONFIG_RULES A
LEFT JOIN AMC_PRODUCT_INFO T ON T.PRODUCT_ID = A.PRODUCT_CODE AND T.STATE = '03'
LEFT JOIN DIC_ALL_KIND K ON K.KIND_ID = A.MARKET_CODE AND K.OPERATION_KIND = 'ma'
LEFT JOIN DIC_ALL_KIND K2 ON K2.KIND_ID = A.TRADE_CODE AND K2.OPERATION_KIND = 'te'
LEFT JOIN DIC_ALL_KIND K3 ON K3.KIND_ID = A.STOCK_PROPERTY  AND K3.OPERATION_KIND = 'sk'
LEFT JOIN DIC_ALL_KIND K4 ON K4.KIND_ID = A.SPLIT_TYPE_CODE  AND K4.OPERATION_KIND = 'sp'
LEFT JOIN DIC_ALL_KIND K5 ON K5.KIND_ID = A.PROPERTY_VALUE
      AND (K5.OPERATION_KIND = 'currency' AND
      A.PROPERTY_TYPE = '01' OR
      K5.OPERATION_KIND = 'domains' AND
      A.PROPERTY_TYPE = '02')
LEFT JOIN DIC_ALL_KIND K6 ON K6.KIND_ID = A.SCOPE_BASE AND K6.OPERATION_KIND = 'split_bs'
WHERE 1 = 1 

 也很希望您不要这样写....