Performance issues after upgrading to Mysql 8.0.19 version

Few queries are performing very poorly after the upgrade. Here are the examples. ****Example 1**:** SELECT x.CI_TITLE 'ciTitle', x.DEPARTMENT_MEANING 'departmentMeaning', x.RESIDUAL_FINANCIAL_IMPACT_LOSS 'residualFinancialImpactLoss', x.INHERENT_CONFIDENTIALITY 'inherentConfidentiality', x.PRIMARY_FLAG 'primaryFlag', x.MEDIA_IMPACT_COMMENT 'mediaImpactComment', x.OPEN_CHALLENGE 'openChallenge' FROM omb_risk_latest_eval_v x WHERE x.COMPANY_ID = 187 ORDER BY x.LAST_UPDATE_DATE DESC LIMIT 30 OFFSET 0 The above query is taking average of 1.2 sec in 5.7.24, however the same query is taking 26 secs in 8.0.19. Here are certain things I tried my level best. 1) All the tables have indexes present 2)Rebuilt all the tables in 8 version using alter table engine=innodb; 3) Checked the optimizer switch variables. Compared in both versions. Found the below 3 were extra skip_scan=on hash_join=on Tried by disabling them, but no impact 4)googled many forums for such kind of issues. They suggested the below but these didn't work. condition_fanout_filter=off internal_tmp_mem_storage_engine=MEMORY suggestions from the below sites.. http://dimitrik.free.fr/blog/archives/2018/04/mysql-performance-testing-80-with-less-blood.html https://www.percona.com/blog/2018/05/04/how-binary-logs-affect-mysql-8-0-performance/ Also we are confident that there could be some server side settings which should be disabled explicitly in 8.x version of MYSQL, as these queries are performing very well in 5.7. Wanted to share the exec plan for both versions but not sure how to do it as we have only image as attachment Any suggestions/help please... I