摘要:
用mysql/innodb测试Q18慢SQL
硬件环境:
- 内存8GB
- cpu8核
- mysql: 8.0.28
explain分析:
[root@localhost ~]# mysql -D tpch -e " > explain select > c_name, > c_custkey, > o_orderkey, > o_orderdate, > o_totalprice, > sum(l_quantity) > from > customer, > orders, > lineitem > where > o_orderkey in ( > select > l_order