search

XiaoMi / soar

SQL Optimizer And Rewriter
Apache License 2.0
8.67k stars 1.32k forks source link

sql执行计划扫描行数超过 设定的阈值explain-max-rows: 5000 没有给出提示 #168

Closed himura-kenshin closed 5 years ago

himura-kenshin commented 5 years ago

image

  1. What version of are you using (soar -version)?

0.9.0

martianzhang commented 5 years ago

红圈的内容就是提示了，'**' 是markdown加粗字体的语法，前面还有一个骷髅头。 👅 @himura-kenshin

himura-kenshin commented 5 years ago

哦哦 这个索引比较低效 可以 让 soar 生成高效索引 输出吗？

himura-kenshin commented 5 years ago

就像美团SQLAdvisor 一样 直接给出最优的索引建议

martianzhang commented 5 years ago

@himura-kenshin 请提供一下查询SQL和建表语句，截图中并没有需要优化的SQL语句。

himura-kenshin commented 5 years ago 
SELECT id, 
       is_delete, 
       process_type, 
       city_id, 
       order_id, 
       shop_id, 
       shop_name, 
       shop_phone, 
       rider_id, 
       rider_name, 
       rider_type, 
       rider_phone, 
       consumer_phone, 
       punish_reason, 
       punish_subject, 
       punish_id, 
       actual_punish_amt, 
       revoker_id, 
       revoker_name, 
       revoke_time, 
       order_finish_time, 
       shop_toll, 
       rider_pay, 
       order_distance, 
       create_time, 
       update_time 
FROM   risk_control 
WHERE  punish_id = 3332391 
       AND punish_subject = 5 
       AND punish_reason = 7 
       AND order_finish_time >= '2018-12-15 00:00:00' 
       AND order_finish_time <= '2018-12-15 23:59:59.999' 
       AND process_type = 2
himura-kenshin commented 5 years ago

image

这个是美团点评给出的索引建议 不过也不是很好的建议

martianzhang commented 5 years ago

@himura-kenshin 建表语句辛苦也提供一下，如果已经存在了索引，SOAR并不会给重复的建议。

himura-kenshin commented 5 years ago

哦哦 ，好的 了解