有没有哪个大神能帮我优化一下这个 oracle sql，多余的字段我删除了，只有待优化的语句。

2023-10-18 15:21:35 574 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Origin作图——等高线图最近做一个测试数据图，开始想通过用热图来展示，结果发现热图有很多的小方块，很难呈现出最好的效果，因为数据是有一层一层的递进效果，因此经过尝试后，发现等高线图是个好选择。热图展示效果如下：其中有很多的小方块不适合，热图制图方法前面有记录。下面展示等高线图制作方法。首先是导入数据，可以从excal导入，也可以直接复制进去。等方法。选中要展示的数据，绘图----等高线图选中箭头，确定。双击图像，点击线，我们需要把线隐藏了. 双击图像，我们需要调色板，根据自己的选择，一般用调色板的颜色。阅读详情

pharmacy.drug_stock 150000个

comm.drug_price_list 40000个

其余表中不超过1000个数量

select
(select amount_per_package
from comm.drug_price_list
where drug_code = d.drug_code
and min_spec = d.drug_spec
and drug_spec <> d.drug_spec
and firm_id = d.firm_id
and min_units = d.units
and units <> d.units
and start_date <= sysdate
and (stop_date >= sysdate or stop_date is null)
and rownum <= 1) as quantityPerPackage,
(select units
from comm.drug_price_list
where drug_code = d.drug_code
and min_spec = d.drug_spec
and drug_spec <> d.drug_spec
and firm_id = d.firm_id
and min_units = d.units
and units <> d.units
and start_date <= sysdate
and (stop_date >= sysdate or stop_date is null)
and rownum <= 1) as packageUnitCode,
(select units
from comm.drug_price_list
where drug_code = d.drug_code
and min_spec = d.drug_spec
and drug_spec <> d.drug_spec
and firm_id = d.firm_id
and min_units = d.units
and units <> d.units
and start_date <= sysdate
and (stop_date >= sysdate or stop_date is null)
and rownum <= 1) as packageUnit,
c.quantity -
(select nvl(sum(db.quantity), 0)
from drug_presc_master_temp da, drug_presc_detail_temp db
where da.presc_date = db.presc_date
and da.presc_no = db.presc_no
and db.drug_code = c.drug_code
and db.drug_spec = c.drug_spec
and db.firm_id = c.firm_id
and db.package_units = c.units
and da.dispensary = c.storage
and db.quantity > 0) as storeNum,
from comm.drug_dict a,
comm.drug_name_dict b,
comm.drug_price_list d,
pharmacy.drug_storage_dept e,
pharmacy.drug_kssxx g,
pharmacy.drug_jbyw h,
pharmacy.drug_same_yp i,
pharmacy.drug_stock c,
pharmacy.kss_drug_ps f
where a.drug_code = b.drug_code
and a.drug_code = c.drug_code
and a.drug_spec = c.drug_spec
and a.units = c.units
and a.drug_code = d.drug_code
and c.package_spec = d.drug_spec
and c.package_units = c.units
and c.firm_id = d.firm_id
and c.storage = e.storage_code
and a.drug_code = f.drug_code(+)
and a.drug_code = g.drug_code(+)
and a.drug_code = h.drug_code(+)
and a.drug_code = i.drug_code(+)
and e.serial_no is not null
and b.std_indicator in (0, 1)
and (c.supply_indicator = 1 or c.drug_bz = 1)
and (d.stop_date >= sysdate or d.stop_date is null)
and d.start_date <= sysdate
;