oracle中关于clob类型字段的查询效率问题

修改后查询，发现还是很慢，于是将其它不需要的字段去掉，调整为：

SELECT
  i.id,i.gmt_create,i.code,i.invoice_tax_val,m.code materials_code,m.name materials_name,s.code supplier_code,s.name supplier_name,it.tax_rate,i.tax_amount,iiod.current_differ_price,i.invoice_val,pid.unit_price * pid.invoice_amt total_money,dbms_lob.substr(iiod.dispense_num,1) dispense_num,decode(i.invoice_type,‘1‘,‘供应商平台‘,‘2‘,‘发票平台‘)
            
FROM
    p_invoice_detail pid
    LEFT JOIN p_invoice i ON pid.invoice_id = i.id
    LEFT JOIN s_materials m ON pid.materials_id = m.id
    LEFT JOIN p_invoice_inform_order_detail iiod ON pid.inform_order_detail_id = iiod.id
    LEFT JOIN p_invoice_inform_order iio ON iiod.invoice_inform_order_id = iio.id
    LEFT JOIN p_invoice_tax it ON i.id = it.invoice_id
    LEFT JOIN s_supplier s ON s.id = i.supplier_id 
WHERE
    i.is_deleted = 0

?

这次总算不报错了，虽然查询单速度还是有点慢，但还能接受：

（编辑：PHP编程网 - 钦州站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!