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))

收藏
分享
2条回答
默认
最新
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏

评论
