terrymanu commented on issue #3215: SQL execution is slow under sub-database sub-table URL: https://github.com/apache/incubator-shardingsphere/issues/3215#issuecomment-540898209 Using SQL like this way: ```sql select id,first_channel, sku_code, version,second_channel,warehouse_code,warehouse_type, inventory_num, normal_inventory_num, damage_inventory_num, locked_num, normal_locked_num, damage_locked_num, transit_num,is_disable,is_deleted from ic_sku_channel_inventory where ( (sku_code in ( ?, ?) AND warehouse_code = ? AND first_channel=? AND second_channel = ?) or (sku_code in ( ?) AND warehouse_code = ? AND first_channel=? AND second_channel = ?) ); ```
---------------------------------------------------------------- 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
