2022-07-18 mysql/stonedb-exists子查询的剔除遍历处理

目录

摘要:

执行的SQL语句:

核心函数处理:

ParameterizedFilter::UpdateMultiIndex

导致exists子查询遍历处理的逻辑:

优化策略:

思路:

优化后的遍历核心代码:

测试数据:

优化exists判断后的子查询耗时:

对比未优化前的子查询耗时:

优化后的火焰图:

优化exists判断后的处理逻辑:

---

摘要:

记录对exists子句进行剔除遍历的处理, 对比优化前后子查询耗时

执行的SQL语句:

/stonedb57/install/bin/mysql -D tpch -e " explain select
o_orderpriority,
count(*) as order_count
from
orders
where
o_orderdate >= date '1993-07-01'
and o_orderdate < date '1993-07-01' + interval '3' month
and exists (
select
*
from
lineitem
where
l_orderkey = o_orderkey
and l_commitdate < l_receiptdate
)
group by
o_orderpriority
order by
                            o_orderpriority ;"

核心函数处理: