8.0.11 +----+--------------------+---------------------+------------+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------+---------+-------------------------------------------+------+----------+------------------------------------+ | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra | +----+--------------------+---------------------+------------+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------+---------+-------------------------------------------+------+----------+------------------------------------+ | 1 | PRIMARY | IWA_Case | NULL | index | NULL | PRIMARY | 8 | NULL | 9846 | 100.00 | Using where | | 1 | PRIMARY | IWA_User | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Case.CreatorUserId | 1 | 100.00 | Using index | | 2 | DEPENDENT SUBQUERY | IWA_Case | NULL | eq_ref | PRIMARY,IWA_Case_CreatorUserIdIndex | PRIMARY | 8 | func | 1 | 100.00 | Using where | | 2 | DEPENDENT SUBQUERY | IWA_User | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Case.CreatorUserId | 1 | 100.00 | Using index | | 2 | DEPENDENT SUBQUERY | IWA_Case | NULL | eq_ref | PRIMARY | PRIMARY | 8 | func | 1 | 100.00 | Using where; Using index | | 2 | DEPENDENT SUBQUERY | IWA_Task | NULL | ref | IWA_Task_CaseIdIndex,IWA_Task_WorkerUserIdIndex,IWA_Task_ActivatorUserIdIndex,IWA_Task_ActivatorRoleIdIndex,IWA_Task_ExpiryActivatorUserIdIndex,IWA_Task_ExpiryActivatorRoleIdIndex,IWA_Task_StateIndex | IWA_Task_CaseIdIndex | 8 | func | 1 | 100.00 | Using index condition; Using where | | 2 | DEPENDENT SUBQUERY | ActivatorRole | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ActivatorRoleId | 1 | 100.00 | Using index | | 2 | DEPENDENT SUBQUERY | ExpiryActivatorRole | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ExpiryActivatorRoleId | 1 | 100.00 | Using index | | 2 | DEPENDENT SUBQUERY | ActivatorUser | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ActivatorUserId | 1 | 100.00 | Using index | | 2 | DEPENDENT SUBQUERY | ExpiryActivatorUser | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ExpiryActivatorUserId | 1 | 100.00 | Using index | | 2 | DEPENDENT SUBQUERY | WorkerUser | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.WorkerUserId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | IWA_Case | NULL | eq_ref | PRIMARY,IWA_Case_CreatorUserIdIndex | PRIMARY | 8 | func | 1 | 100.00 | Using where | | 3 | DEPENDENT UNION | IWA_User | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Case.CreatorUserId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | IWA_Case | NULL | ref | PRIMARY,IWA_Case_BusinessCaseIdIndex | IWA_Case_BusinessCaseIdIndex | 9 | func | 9846 | 100.00 | Using where; Using index | | 3 | DEPENDENT UNION | IWA_Task | NULL | ref | IWA_Task_CaseIdIndex,IWA_Task_WorkerUserIdIndex,IWA_Task_ActivatorUserIdIndex,IWA_Task_ActivatorRoleIdIndex,IWA_Task_ExpiryActivatorUserIdIndex,IWA_Task_ExpiryActivatorRoleIdIndex,IWA_Task_StateIndex | IWA_Task_CaseIdIndex | 8 | TstPerfV58.IWA_Case.CaseId | 1 | 100.00 | Using where | | 3 | DEPENDENT UNION | ActivatorRole | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ActivatorRoleId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | ExpiryActivatorRole | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ExpiryActivatorRoleId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | ActivatorUser | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ActivatorUserId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | ExpiryActivatorUser | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ExpiryActivatorUserId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | WorkerUser | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.WorkerUserId | 1 | 100.00 | Using index | | NULL | UNION RESULT | | NULL | ALL | NULL | NULL | NULL | NULL | NULL | NULL | Using temporary | +----+--------------------+---------------------+------------+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------+---------+-------------------------------------------+------+----------+------------------------------------+ 21 rows in set, 1 warning (0.02 sec) 8.0.12 +----+--------------------+---------------------+------------+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+---------+-------------------------------------------+-------+----------+----------------------------------------------------+ | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra | +----+--------------------+---------------------+------------+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+---------+-------------------------------------------+-------+----------+----------------------------------------------------+ | 1 | PRIMARY | IWA_Case | NULL | index | NULL | PRIMARY | 8 | NULL | 9795 | 100.00 | Using where | | 1 | PRIMARY | IWA_User | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Case.CreatorUserId | 1 | 100.00 | Using index | | 2 | DEPENDENT SUBQUERY | IWA_Case | NULL | eq_ref | PRIMARY,IWA_Case_CreatorUserIdIndex | PRIMARY | 8 | func | 1 | 100.00 | Using where | | 2 | DEPENDENT SUBQUERY | IWA_Case | NULL | eq_ref | PRIMARY | PRIMARY | 8 | func | 1 | 100.00 | Using where; Using index | | 2 | DEPENDENT SUBQUERY | IWA_User | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Case.CreatorUserId | 1 | 100.00 | Using index | | 2 | DEPENDENT SUBQUERY | IWA_Task | NULL | ref | IWA_Task_CaseIdIndex,IWA_Task_WorkerUserIdIndex,IWA_Task_ActivatorUserIdIndex,IWA_Task_ActivatorRoleIdIndex,IWA_Task_ExpiryActivatorUserIdIndex,IWA_Task_ExpiryActivatorRoleIdIndex,IWA_Task_StateIndex | IWA_Task_CaseIdIndex | 8 | func | 2 | 100.00 | Using index condition; Using where | | 2 | DEPENDENT SUBQUERY | ActivatorRole | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ActivatorRoleId | 1 | 100.00 | Using index | | 2 | DEPENDENT SUBQUERY | ExpiryActivatorRole | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ExpiryActivatorRoleId | 1 | 100.00 | Using index | | 2 | DEPENDENT SUBQUERY | ActivatorUser | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ActivatorUserId | 1 | 100.00 | Using index | | 2 | DEPENDENT SUBQUERY | ExpiryActivatorUser | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ExpiryActivatorUserId | 1 | 100.00 | Using index | | 2 | DEPENDENT SUBQUERY | WorkerUser | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.WorkerUserId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | IWA_Case | NULL | eq_ref | PRIMARY,IWA_Case_CreatorUserIdIndex | PRIMARY | 8 | func | 1 | 100.00 | Using where | | 3 | DEPENDENT UNION | IWA_User | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Case.CreatorUserId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | IWA_Task | NULL | ALL | IWA_Task_CaseIdIndex,IWA_Task_WorkerUserIdIndex,IWA_Task_ActivatorUserIdIndex,IWA_Task_ActivatorRoleIdIndex,IWA_Task_ExpiryActivatorUserIdIndex,IWA_Task_ExpiryActivatorRoleIdIndex,IWA_Task_StateIndex | NULL | NULL | NULL | 18810 | 100.00 | Using where; Using join buffer (Block Nested Loop) | | 3 | DEPENDENT UNION | ActivatorRole | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ActivatorRoleId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | ExpiryActivatorRole | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ExpiryActivatorRoleId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | ActivatorUser | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ActivatorUserId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | ExpiryActivatorUser | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ExpiryActivatorUserId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | WorkerUser | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.WorkerUserId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | IWA_Case | NULL | eq_ref | PRIMARY,IWA_Case_BusinessCaseIdIndex | PRIMARY | 8 | TstPerfV58.IWA_Task.CaseId | 1 | 100.00 | Using where | | NULL | UNION RESULT | | NULL | ALL | NULL | NULL | NULL | NULL | NULL | NULL | Using temporary | +----+--------------------+---------------------+------------+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+---------+-------------------------------------------+-------+----------+----------------------------------------------------+ 21 rows in set, 1 warning (0.02 sec) 8.0.15 +----+--------------------+---------------------+------------+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+---------+-------------------------------------------+-------+----------+----------------------------------------------------+ | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra | +----+--------------------+---------------------+------------+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+---------+-------------------------------------------+-------+----------+----------------------------------------------------+ | 1 | PRIMARY | IWA_Case | NULL | index | NULL | PRIMARY | 8 | NULL | 10022 | 100.00 | Using where | | 1 | PRIMARY | IWA_User | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Case.CreatorUserId | 1 | 100.00 | Using index | | 2 | DEPENDENT SUBQUERY | IWA_Case | NULL | eq_ref | PRIMARY,IWA_Case_CreatorUserIdIndex | PRIMARY | 8 | func | 1 | 100.00 | Using where | | 2 | DEPENDENT SUBQUERY | IWA_User | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Case.CreatorUserId | 1 | 100.00 | Using index | | 2 | DEPENDENT SUBQUERY | IWA_Case | NULL | eq_ref | PRIMARY | PRIMARY | 8 | func | 1 | 100.00 | Using where; Using index | | 2 | DEPENDENT SUBQUERY | IWA_Task | NULL | ref | IWA_Task_CaseIdIndex,IWA_Task_WorkerUserIdIndex,IWA_Task_ActivatorUserIdIndex,IWA_Task_ActivatorRoleIdIndex,IWA_Task_ExpiryActivatorUserIdIndex,IWA_Task_ExpiryActivatorRoleIdIndex,IWA_Task_StateIndex | IWA_Task_CaseIdIndex | 8 | func | 1 | 100.00 | Using index condition; Using where | | 2 | DEPENDENT SUBQUERY | ActivatorRole | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ActivatorRoleId | 1 | 100.00 | Using index | | 2 | DEPENDENT SUBQUERY | ExpiryActivatorRole | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ExpiryActivatorRoleId | 1 | 100.00 | Using index | | 2 | DEPENDENT SUBQUERY | ActivatorUser | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ActivatorUserId | 1 | 100.00 | Using index | | 2 | DEPENDENT SUBQUERY | ExpiryActivatorUser | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ExpiryActivatorUserId | 1 | 100.00 | Using index | | 2 | DEPENDENT SUBQUERY | WorkerUser | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.WorkerUserId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | IWA_Case | NULL | eq_ref | PRIMARY,IWA_Case_CreatorUserIdIndex | PRIMARY | 8 | func | 1 | 100.00 | Using where | | 3 | DEPENDENT UNION | IWA_User | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Case.CreatorUserId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | IWA_Task | NULL | ALL | IWA_Task_CaseIdIndex,IWA_Task_WorkerUserIdIndex,IWA_Task_ActivatorUserIdIndex,IWA_Task_ActivatorRoleIdIndex,IWA_Task_ExpiryActivatorUserIdIndex,IWA_Task_ExpiryActivatorRoleIdIndex,IWA_Task_StateIndex | NULL | NULL | NULL | 18700 | 100.00 | Using where; Using join buffer (Block Nested Loop) | | 3 | DEPENDENT UNION | ActivatorRole | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ActivatorRoleId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | ExpiryActivatorRole | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ExpiryActivatorRoleId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | ActivatorUser | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ActivatorUserId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | ExpiryActivatorUser | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.ExpiryActivatorUserId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | WorkerUser | NULL | eq_ref | PRIMARY | PRIMARY | 8 | TstPerfV58.IWA_Task.WorkerUserId | 1 | 100.00 | Using index | | 3 | DEPENDENT UNION | IWA_Case | NULL | eq_ref | PRIMARY,IWA_Case_BusinessCaseIdIndex | PRIMARY | 8 | TstPerfV58.IWA_Task.CaseId | 1 | 100.00 | Using where | | NULL | UNION RESULT | | NULL | ALL | NULL | NULL | NULL | NULL | NULL | NULL | Using temporary | +----+--------------------+---------------------+------------+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+---------+-------------------------------------------+-------+----------+----------------------------------------------------+ 21 rows in set, 1 warning (0.01 sec)