[GitHub] [shardingsphere] mandone commented on issue #24572: how to change the final execute sql like content

["mandone (via GitHub)" <gi...@apache.org>]

mandone commented on issue #24572:
URL: https://github.com/apache/shardingsphere/issues/24572#issuecomment-1469187710

   this is my sql before route
   
   ```sql
   select day_value as id_date, avg(success_count) as success, avg(failed_count) as fail
   from t_sdk_stat_count_xxxt_sdk_202301
   where sdk_code = 'xxx_sdk'
     and day_value >= '20221201'
     and day_value <= '20230301'
     and month_value >= '202212'
     and month_value <= '202303'
   group by day_value;
   ```
   
   I want change my finally execute sql to 
   
   ```sql
   select day_value as id_date, avg(success_count) as success, avg(failed_count) as fail
   from t_sdk_stat_count_xxx_sdk_202301 
   where day_value >= '20221201'
     and day_value <= '20230301'
   group by day_value;
   ```
   maybe execute faster
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org