young138120 opened a new issue, #25301: URL: https://github.com/apache/shardingsphere/issues/25301
I have two sharding table with sharding key named `order_id`, and they are binding table when i execute the sql , it is will block long time and will be oom after a few min ```sql select o.order_number from or_rescue_order o left join or_order_task task on task.public_no = o.public_no where o.public_no=530235903497179136; ``` i just know ss proxy server goes to search all of sharding table in memory ,but why is it do that ?  i think the ss proxy server should execute the sql on all sharding database , but the server search all of order table in memory at first so all of sql like that sharding table join should use sharding key , if not the ss proxy server will shutdown ? -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
