一个sql 优化解决办法

  SQL Statement from editor:        select c0602 "商品编码",c0625 "商品条码",    c0103 "商品名称",c0104 "规格",c0604 "配货件数",    c0605 "配货数量",c0618 "计划赠品数",c0606 "实际出库数",    c0621 "出库赠品数",c0610 "门店实收数",c0611 "实收赠品数",    c0609 "剩余商品入库",c0622 "剩余商品报损"     from c05 t1,c06,vc01 where c0501=c0601  and c0602=c0101      and c0538    between to_date('2009.1.1','yyyy-mm-dd') and to_date('2009.2.28','yyyy-mm-dd')  ------------------------      Statement Id=7   Type=INDEX  Cost=2  TimeStamp=21-04-10::09::44:47         (1)  SELECT STATEMENT  CHOOSE      Est. Rows: 23,043  Cost: 11,365       (10)  MERGE JOIN      Est. Rows: 23,043  Cost: 11,365           (7)  SORT JOIN                 Est. Rows: 23,043  Cost: 6,538               (6)  TABLE ACCESS BY INDEX ROWID FZDC.C06  [Analyzed]                (6)   Blocks: 34,464 Est. Rows: 35 of 2,411,508  Cost: 9                     Tablespace: FZ_DAT                   (5)  NESTED LOOPS                         Est. Rows: 23,043  Cost: 6,017                       (3)  TABLE ACCESS BY INDEX ROWID FZDC.C05  [Analyzed]                        (3)   Blocks: 7,944 Est. Rows: 668 of 406,159  Cost: 5                             Tablespace: FZ_DAT                           (2)  NON-UNIQUE INDEX RANGE SCAN FZDC.IND_C05_C0538  [Not Analyzed]                                 Est. Rows: 1,055  Cost: 2                       (4)  UNIQUE INDEX RANGE SCAN FZDC.SYS_C005366  [Analyzed]                             Est. Rows: 35  Cost: 2           (9)  SORT JOIN                 Est. Rows: 305,274  Cost: 4,827               (8)  TABLE ACCESS FULL FZDC.C01  [Analyzed]                (8)   Blocks: 10,492 Est. Rows: 305,274 of 305,274  Cost: 1,594                     Tablespace: FZ_DAT