一个sql 优化 - Oracle / 开发

SQL code:


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