fzyzcjy opened a new issue, #24480: URL: https://github.com/apache/shardingsphere/issues/24480
## Feature Request Related to: https://github.com/apache/shardingsphere/issues/24478 Hi, thanks for the package! I wonder whether it is possible to selectively broadcast to the databases that contain the data, based on non-sharding key? Again using the dummy example in the last issue: Suppose we have a `message` table with columns `chat_id`, `message_id`, `another_id`, with `chat_id` being the sharding key. Then, we have a SQL like `SELECT ... WHERE another_id IN (100, 200, 300) AND ...`. Suppose, for simplicity, we have 64 shards, and suppose we know another_id=100,200 is in shard A and another_id=300 is in shard B. Then, ideally, shardingsphere should only send (modified) query to shard A and B, instead of all 64 shards (which is very expensive). So, is this possible? Thanks. ### Is your feature request related to a problem? see above ### Describe the feature you would like. see above -- 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]
