Akigaze opened a new issue #4947: Is there any way to traverse tables in the specified order by Schema & Table Route URL: https://github.com/apache/incubator-shardingsphere/issues/4947 ## Question **logic table:** t_msg (**column:** created_time (*sharding key*), version, business_key) **physical table:** t_msg, t_msg_20_3, t_msg_20_4, t_msg_20_5 ... I use **Oracle** database and now I want to find the frist record of specific `business_key`: **SQL:** `select * from t_msg where business_key=? fetch first 1 rows only;` For this one I know the sharding-jdbc will use Schema & Table Route strategy, and the result SQL is: > select * from t_msg where business_key = ?; select * from t_msg_20_3 where business_key = ?; select * from t_msg_20_4 where business_key = ?; select * from t_msg_20_5 where business_key = ?; ... ... But now it's March so I want it to search start with `t_msg_20_3`. And once finding out a record, I hope it can return immediately, not need to search in `t_msg` anymore. If nothing can be found in `t_msg_20_3`, it will continue to look for `t_msg`. Is there any strategy or setting of sharding-jdbc can support this requirement?
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
