explain analyze select count(ol_i_id), count(ol_supply_w_id), count(ol_delivery_d) from order_line where ol_i_id <= 100000 and ol_supply_w_id <= 1500 and (ol_delivery_d >= "2021-12-27 09:25:34" or ol_delivery_d is NULL)
Where order_line has 452038522 rows, the profile shows logical operator is very slow in TiFlash(takes up almost 70% cpu time), which is not expected.
Enhancement
Running query
Where
order_line
has 452038522 rows, the profile shows logical operator is very slow in TiFlash(takes up almost 70% cpu time), which is not expected.