暂无图片
分享
卢春龙
2019-09-17
INDEX FULL SCAN 要怎么优化呢谢谢

有没有办法优化呢?

DELETE FROM t_bas_voucherEntry WHERE EXISTS (SELECT 1 FROM t_bas_voucher T0 INNER JOIN ( select COLUMN_VALUE as FID from TABLE(cast(:FID_udt as udt_inttable))) t1 ON t0.FSourceBillID = t1.FID WHERE (t0.FSourceBillKey = :SourceBillKey AND t0.FVoucherId = t_bas_voucherEntry.FVoucherId))

image.png


收藏
分享
2条回答
默认
最新
Moone

改写SQL试试:

DELETE FROM t_bas_voucherEntry WHERE FVoucherId IN (SELECT FVoucherId FROM t_bas_voucher T0 INNER JOIN ( select COLUMN_VALUE as FID from TABLE(cast(:FID_udt as udt_inttable))) t1 ON t0.FSourceBillID = t1.FID WHERE (t0.FSourceBillKey = :SourceBillKey and t0.FVoucherId is not null))

暂无图片 评论
暂无图片 有用 0
卢春龙
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏