I am planning to upgrade my project from mysql 5.6 to 8 but after migration it is found that few of the functionality performance degraded so in further deep dive it is found that from mysql-7 Condition Filtering came into picture whose default value set to ON .
for few query i tried to set the value off and check the query performance
SET optimizer_switch = 'condition_fanout_filter=off' ;
so it was working fine. at least i got the query performance similar to mysql 5.6.
so do we need to check each and every query and set the condition filteting ON/OFF explicity or is there any global solution for same?
