使用USE_HASH Hint调优一个SQL语句

开发的同事写了个很长的SQL， 执行效率低下，于是找到我：
SQL如下：

点击(此处)折叠或打开

1. SELECT w.wareid,
   
2.        w.warename,
   
3.        w.warespec,
   
4.        w.wareunit,
   
5.        w.factoryid,
   
6.        w.bandcode,
   
7.        w.lastpurprice,
   
8.        ws.saleprice,
   
9.        CASE
   
10.          WHEN ws.saleprice = 0 THEN
    
11.           0
    
12.          ELSE
    
13.           round((ws.saleprice - w.lastpurprice) / ws.saleprice, 4)
    
14.        END mll,
    
15.        fl.fl,
    
16.        zkc.xl1,
    
17.        s2.xl2,
    
18.        zkc.xl5,
    
19.        zkc.xl3,
    
20.        zkc.xl4,
    
21.        zbkc.zbkc,
    
22.        CASE
    
23.          WHEN nvl(xl4, 0) = 0 THEN
    
24.           0
    
25.          ELSE
    
26.           round(zbkc.zbkc / xl4, 4)
    
27.        END cxb,
    
28.        zkc.zkc,
    
29.        CASE
    
30.          WHEN xl4 = 0 THEN
    
31.           0
    
32.          ELSE
    
33.           round(zkc.zkc / xl4, 4)
    
34.        END zcxb,
    
35.        round(CASE
    
36.                WHEN zkc.zkc = 0 THEN
    
37.                 0
    
38.                ELSE
    
39.                 (zkc.zkc - zbkc.zbkc) / zkc.zkc
    
40.              END,
    
41.              4) fdkcbfb,
    
42.        nvl(xl4, 0) * xs.xs - zbkc.zbkc bhl,
    
43.        w.midqty,
    
44.        v.cashtype,
    
45.        nvl(h.sumpendingqty, 0) sumpendingqty,
    
46.        s6.zdxl,
    
47.        s6.zdxsje,
    
48.        w.purstatus,
    
49.        w.salestatus,
    
50.        zkc.xsje,
    
51.        zkc.zkcje,
    
52.        zbkc.zbkcje,
    
53.        w.purtax,
    
54.        wc.classcode jx,
    
55.        wb.fileno,
    
56.        w.inittime,
    
57.        we.we_num03,
    
58.        we.we_lchar03,
    
59.        w.store_req,
    
60.        we.we_lchar02,
    
61.        w.warningdays,
    
62.        CASE
    
63.          WHEN wc2.classcode = '3302' THEN
    
64.           '是'
    
65.          ELSE
    
66.           '否'
    
67.        END otc,
    
68.        wc3.classcode,
    
69.        w.waremark,
    
70.        fl.vendorno1 gysbh,
    
71.        fl