SELECT SQL_NO_CACHE EMAILSTORE.ISFORMEMAIL, EMAILSTORE.SENDDATE, EMAILSTORE.SUBJECT, EMAILSTORE.XFROM, EMAILSTORE.XTO, EMAILSTORE.HASATTACHMENTS, EMAILSTORE.GGUID FROM `svg`.EMAILSTORE0 AS EMAILSTORE WHERE ((EMAILSTORE.GGUID IN (SELECT rel.GUID1 FROM `svg`.TableRelation AS rel INNER JOIN `svg`.TODO0 AS TODOC7504C2A4C0C38BDBE403DA9CA19A0DF ON rel.GUID2 = TODOC7504C2A4C0C38BDBE403DA9CA19A0DF.GGUID WHERE ((TODOC7504C2A4C0C38BDBE403DA9CA19A0DF.KEYWORD LIKE '%antragsanforderung%' AND TODOC7504C2A4C0C38BDBE403DA9CA19A0DF.WORKINGPERCENT = '100') AND (TODOC7504C2A4C0C38BDBE403DA9CA19A0DF.GGUID IN (SELECT TABLEGUID FROM `svg`.TODOORel WHERE EIMRight >= 64 AND (OID IN (1014, -426, -396, -98, -305, -50, -215, -8, -100, -366, -88, -90, -279, -319, -314, -270, -99, -428, -92, -431, -317, -427, -430, -320, -95, -101, 0) OR (OID IN (4328, -314, -215, -159, -216, 4389, 4390, 4392, 4093, 4399, 4109, 4355, 4114, 4115, 1032, 1033, 1034, 3055, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 3756, 3755, 4456, 4443, 4189, 3519, 3406, 3944, 3407, 3945, 3946, 3947, 3936, 3937, 3938, 3939, 3940, 3941, 3942, 3943, 4527, 4226, 3453, 3454, 3935, 3934, 1016, 3096, 1017, 1018, 4332, 1019, 1020, 1021, 1022, 1023, 3089, 1008, 1009, 3091, 1010, 3090, 3093, 1012, 1013, 3094, 1015, 1001, 1000, 1003, 1002, 1005, 1004, 1007, 1006, 997, 996, 999, 3616, 3613, 3855, 3615, 3852, 3609, 3850, 3608, 3848, 3610, 3849, 3846, 3847, 3607, 3844, 3606, 3845, 3842, 3843, 3840, 3841, 4550, 4400, 4401, 4402, 4403, 4464, 4404, 4465, 4461, 4460, 4463, 4462, 4457, 4459, 4458, 3600, 3596, 3597, 3598, 3599, 3592, 3593, 3594, 3595, 3588, 3589, 3590, 3591, -93, -101, -8, -99, -50, -95, -100, -98, -92, -161, -380, -217, -148, -307, -90, -323, -321, -110, -150, -103, -109, -107, -149, -218, -324, -88, -415, -319, -320, -305, -317, -427, -357, -270, -279, -428, -105, -366, -91, -102, -365, -306, -313, -311, -308, -309, -9) AND TODOC7504C2A4C0C38BDBE403DA9CA19A0DF.ForeignEditPermission = 65535))))) AND (TODOC7504C2A4C0C38BDBE403DA9CA19A0DF.ISDELETED = 0 AND TODOC7504C2A4C0C38BDBE403DA9CA19A0DF.ISTEMPLATE = 0))) AND (EMAILSTORE.GGUID IN (SELECT TABLEGUID FROM `svg`.EMAILSTOREORel WHERE EIMRight >= 64 AND (OID IN (1014, -426, -396, -98, -305, -50, -215, -8, -100, -366, -88, -90, -279, -319, -314, -270, -99, -428, -92, -431, -317, -427, -430, -320, -95, -101, 0) OR (OID IN (4328, -314, -215, -159, -216, 4389, 4390, 4392, 4093, 4399, 4109, 4355, 4114, 4115, 1032, 1033, 1034, 3055, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 3756, 3755, 4456, 4443, 4189, 3519, 3406, 3944, 3407, 3945, 3946, 3947, 3936, 3937, 3938, 3939, 3940, 3941, 3942, 3943, 4527, 4226, 3453, 3454, 3935, 3934, 1016, 3096, 1017, 1018, 4332, 1019, 1020, 1021, 1022, 1023, 3089, 1008, 1009, 3091, 1010, 3090, 3093, 1012, 1013, 3094, 1015, 1001, 1000, 1003, 1002, 1005, 1004, 1007, 1006, 997, 996, 999, 3616, 3613, 3855, 3615, 3852, 3609, 3850, 3608, 3848, 3610, 3849, 3846, 3847, 3607, 3844, 3606, 3845, 3842, 3843, 3840, 3841, 4550, 4400, 4401, 4402, 4403, 4464, 4404, 4465, 4461, 4460, 4463, 4462, 4457, 4459, 4458, 3600, 3596, 3597, 3598, 3599, 3592, 3593, 3594, 3595, 3588, 3589, 3590, 3591, -93, -101, -8, -99, -50, -95, -100, -98, -92, -161, -380, -217, -148, -307, -90, -323, -321, -110, -150, -103, -109, -107, -149, -218, -324, -88, -415, -319, -320, -305, -317, -427, -357, -270, -279, -428, -105, -366, -91, -102, -365, -306, -313, -311, -308, -309, -9) AND EMAILSTORE.ForeignEditPermission = 65535))))) AND (EMAILSTORE.ISDELETED = 0 AND EMAILSTORE.ISTEMPLATE = 0) ORDER BY EMAILSTORE.SENDDATE DESC, EMAILSTORE.GGUID ASC LIMIT 0, 100{ "steps": [ { "join_preparation": { "select#": 1, "steps": [ { "join_preparation": { "select#": 2, "steps": [ { "join_preparation": { "select#": 3, "steps": [ { "expanded_query": "/* select#3 */ select `todoorel`.`TableGUID` from `todoorel` where ((`todoorel`.`EIMRight` >= 64) and ((`todoorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`todoorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`ForeignEditPermission` = 65535))))" }, { "transformation": { "select#": 3, "from": "IN (SELECT)", "to": "semijoin", "chosen": true } } ] } }, { "expanded_query": "/* select#2 */ select `rel`.`GUID1` from (`tablerelation` `rel` join `todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df` on((`rel`.`GUID2` = `todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID`))) where ((`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`KEYWORD` like '%antragsanforderung%') and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`WORKINGPERCENT` = '100') and `todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID` in (/* select#3 */ select `todoorel`.`TableGUID` from `todoorel` where ((`todoorel`.`EIMRight` >= 64) and ((`todoorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`todoorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`ForeignEditPermission` = 65535))))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsDeleted` = 0) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsTemplate` = 0))" }, { "transformation": { "select#": 2, "from": "IN (SELECT)", "to": "semijoin", "chosen": true } } ] } }, { "join_preparation": { "select#": 4, "steps": [ { "expanded_query": "/* select#4 */ select `emailstoreorel`.`TableGUID` from `emailstoreorel` where ((`emailstoreorel`.`EIMRight` >= 64) and ((`emailstoreorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`emailstoreorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and (`emailstore`.`ForeignEditPermission` = 65535))))" }, { "transformation": { "select#": 4, "from": "IN (SELECT)", "to": "semijoin", "chosen": true } } ] } }, { "expanded_query": "/* select#1 */ select sql_no_cache `emailstore`.`IsFormEMail` AS `ISFORMEMAIL`,`emailstore`.`SendDate` AS `SENDDATE`,`emailstore`.`Subject` AS `SUBJECT`,`emailstore`.`XFrom` AS `XFROM`,`emailstore`.`XTo` AS `XTO`,`emailstore`.`HASATTACHMENTS` AS `HASATTACHMENTS`,`emailstore`.`GGUID` AS `GGUID` from `emailstore0` `emailstore` where (`emailstore`.`GGUID` in (/* select#2 */ select `rel`.`GUID1` from (`tablerelation` `rel` join `todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df` on((`rel`.`GUID2` = `todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID`))) where ((`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`KEYWORD` like '%antragsanforderung%') and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`WORKINGPERCENT` = '100') and `todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID` in (/* select#3 */ select `todoorel`.`TableGUID` from `todoorel` where ((`todoorel`.`EIMRight` >= 64) and ((`todoorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`todoorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`ForeignEditPermission` = 65535))))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsDeleted` = 0) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsTemplate` = 0))) and `emailstore`.`GGUID` in (/* select#4 */ select `emailstoreorel`.`TableGUID` from `emailstoreorel` where ((`emailstoreorel`.`EIMRight` >= 64) and ((`emailstoreorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`emailstoreorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and (`emailstore`.`ForeignEditPermission` = 65535))))) and (`emailstore`.`IsDeleted` = 0) and (`emailstore`.`IsTemplate` = 0)) order by `emailstore`.`SendDate` desc,`emailstore`.`GGUID` limit 0,100" } ] } }, { "join_optimization": { "select#": 1, "steps": [ { "transformation": { "select#": 3, "from": "IN (SELECT)", "to": "semijoin", "chosen": true, "evaluating_constant_semijoin_conditions": [ ] } }, { "transformation": { "select#": 4, "from": "IN (SELECT)", "to": "semijoin", "chosen": true, "evaluating_constant_semijoin_conditions": [ ] } }, { "transformation": { "select#": 2, "from": "IN (SELECT)", "to": "semijoin", "chosen": true, "evaluating_constant_semijoin_conditions": [ ] } }, { "transformations_to_nested_joins": { "transformations": [ "semijoin", "JOIN_condition_to_WHERE", "parenthesis_removal" ], "expanded_query": "/* select#1 */ select sql_no_cache `emailstore`.`IsFormEMail` AS `ISFORMEMAIL`,`emailstore`.`SendDate` AS `SENDDATE`,`emailstore`.`Subject` AS `SUBJECT`,`emailstore`.`XFrom` AS `XFROM`,`emailstore`.`XTo` AS `XTO`,`emailstore`.`HASATTACHMENTS` AS `HASATTACHMENTS`,`emailstore`.`GGUID` AS `GGUID` from `emailstore0` `emailstore` semi join (`emailstoreorel`) semi join (`todoorel` join `tablerelation` `rel` join `todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`) where (1 and 1 and (`emailstore`.`IsDeleted` = 0) and (`emailstore`.`IsTemplate` = 0) and (`emailstoreorel`.`EIMRight` >= 64) and ((`emailstoreorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`emailstoreorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and (`emailstore`.`ForeignEditPermission` = 65535))) and (`emailstore`.`GGUID` = `emailstoreorel`.`TableGUID`) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`KEYWORD` like '%antragsanforderung%') and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`WORKINGPERCENT` = '100') and 1 and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsDeleted` = 0) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsTemplate` = 0) and (`todoorel`.`EIMRight` >= 64) and ((`todoorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`todoorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`ForeignEditPermission` = 65535))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID` = `todoorel`.`TableGUID`) and (`emailstore`.`GGUID` = `rel`.`GUID1`) and (`rel`.`GUID2` = `todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID`)) order by `emailstore`.`SendDate` desc,`emailstore`.`GGUID` limit 0,100" } }, { "condition_processing": { "condition": "WHERE", "original_condition": "(1 and 1 and (`emailstore`.`IsDeleted` = 0) and (`emailstore`.`IsTemplate` = 0) and (`emailstoreorel`.`EIMRight` >= 64) and ((`emailstoreorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`emailstoreorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and (`emailstore`.`ForeignEditPermission` = 65535))) and (`emailstore`.`GGUID` = `emailstoreorel`.`TableGUID`) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`KEYWORD` like '%antragsanforderung%') and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`WORKINGPERCENT` = '100') and 1 and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsDeleted` = 0) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsTemplate` = 0) and (`todoorel`.`EIMRight` >= 64) and ((`todoorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`todoorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`ForeignEditPermission` = 65535))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID` = `todoorel`.`TableGUID`) and (`emailstore`.`GGUID` = `rel`.`GUID1`) and (`rel`.`GUID2` = `todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID`))", "steps": [ { "transformation": "equality_propagation", "resulting_condition": "(1 and 1 and (`emailstoreorel`.`EIMRight` >= 64) and ((`emailstoreorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`emailstoreorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and multiple equal(65535, `emailstore`.`ForeignEditPermission`))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`KEYWORD` like '%antragsanforderung%') and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`WORKINGPERCENT` = '100') and 1 and (`todoorel`.`EIMRight` >= 64) and ((`todoorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`todoorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and multiple equal(65535, `todoc7504c2a4c0c38bdbe403da9ca19a0df`.`ForeignEditPermission`))) and multiple equal(0, `emailstore`.`IsDeleted`) and multiple equal(0, `emailstore`.`IsTemplate`) and multiple equal(`emailstore`.`GGUID`, `emailstoreorel`.`TableGUID`, `rel`.`GUID1`) and multiple equal(0, `todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsDeleted`) and multiple equal(0, `todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsTemplate`) and multiple equal(`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID`, `todoorel`.`TableGUID`, `rel`.`GUID2`))" }, { "transformation": "constant_propagation", "resulting_condition": "(1 and 1 and (`emailstoreorel`.`EIMRight` >= 64) and ((`emailstoreorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`emailstoreorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and multiple equal(65535, `emailstore`.`ForeignEditPermission`))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`KEYWORD` like '%antragsanforderung%') and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`WORKINGPERCENT` = '100') and 1 and (`todoorel`.`EIMRight` >= 64) and ((`todoorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`todoorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and multiple equal(65535, `todoc7504c2a4c0c38bdbe403da9ca19a0df`.`ForeignEditPermission`))) and multiple equal(0, `emailstore`.`IsDeleted`) and multiple equal(0, `emailstore`.`IsTemplate`) and multiple equal(`emailstore`.`GGUID`, `emailstoreorel`.`TableGUID`, `rel`.`GUID1`) and multiple equal(0, `todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsDeleted`) and multiple equal(0, `todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsTemplate`) and multiple equal(`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID`, `todoorel`.`TableGUID`, `rel`.`GUID2`))" }, { "transformation": "trivial_condition_removal", "resulting_condition": "((`emailstoreorel`.`EIMRight` >= 64) and ((`emailstoreorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`emailstoreorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and multiple equal(65535, `emailstore`.`ForeignEditPermission`))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`KEYWORD` like '%antragsanforderung%') and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`WORKINGPERCENT` = '100') and (`todoorel`.`EIMRight` >= 64) and ((`todoorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`todoorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and multiple equal(65535, `todoc7504c2a4c0c38bdbe403da9ca19a0df`.`ForeignEditPermission`))) and multiple equal(0, `emailstore`.`IsDeleted`) and multiple equal(0, `emailstore`.`IsTemplate`) and multiple equal(`emailstore`.`GGUID`, `emailstoreorel`.`TableGUID`, `rel`.`GUID1`) and multiple equal(0, `todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsDeleted`) and multiple equal(0, `todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsTemplate`) and multiple equal(`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID`, `todoorel`.`TableGUID`, `rel`.`GUID2`))" } ] } }, { "table_dependencies": [ { "table": "`emailstore0` `emailstore`", "row_may_be_null": false, "map_bit": 0, "depends_on_map_bits": [ ] }, { "table": "`emailstoreorel`", "row_may_be_null": false, "map_bit": 1, "depends_on_map_bits": [ ] }, { "table": "`tablerelation` `rel`", "row_may_be_null": false, "map_bit": 2, "depends_on_map_bits": [ ] }, { "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "row_may_be_null": false, "map_bit": 3, "depends_on_map_bits": [ ] }, { "table": "`todoorel`", "row_may_be_null": false, "map_bit": 4, "depends_on_map_bits": [ ] } ] }, { "ref_optimizer_key_uses": [ { "table": "`emailstore0` `emailstore`", "field": "GGUID", "equals": "`rel`.`GUID1`", "null_rejecting": true }, { "table": "`emailstore0` `emailstore`", "field": "GGUID", "equals": "`emailstoreorel`.`TableGUID`", "null_rejecting": false }, { "table": "`emailstore0` `emailstore`", "field": "GGUID", "equals": "`emailstoreorel`.`TableGUID`", "null_rejecting": false }, { "table": "`emailstore0` `emailstore`", "field": "GGUID", "equals": "`rel`.`GUID1`", "null_rejecting": true }, { "table": "`emailstoreorel`", "field": "TableGUID", "equals": "`rel`.`GUID1`", "null_rejecting": true }, { "table": "`emailstoreorel`", "field": "TableGUID", "equals": "`emailstore`.`GGUID`", "null_rejecting": false }, { "table": "`emailstoreorel`", "field": "TableGUID", "equals": "`emailstore`.`GGUID`", "null_rejecting": false }, { "table": "`emailstoreorel`", "field": "TableGUID", "equals": "`rel`.`GUID1`", "null_rejecting": true }, { "table": "`tablerelation` `rel`", "field": "GUID1", "equals": "`emailstoreorel`.`TableGUID`", "null_rejecting": false }, { "table": "`tablerelation` `rel`", "field": "GUID1", "equals": "`emailstore`.`GGUID`", "null_rejecting": false }, { "table": "`tablerelation` `rel`", "field": "GUID2", "equals": "`todoorel`.`TableGUID`", "null_rejecting": false }, { "table": "`tablerelation` `rel`", "field": "GUID2", "equals": "`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID`", "null_rejecting": false }, { "table": "`tablerelation` `rel`", "field": "GUID1", "equals": "`emailstore`.`GGUID`", "null_rejecting": false }, { "table": "`tablerelation` `rel`", "field": "GUID1", "equals": "`emailstoreorel`.`TableGUID`", "null_rejecting": false }, { "table": "`tablerelation` `rel`", "field": "GUID2", "equals": "`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID`", "null_rejecting": false }, { "table": "`tablerelation` `rel`", "field": "GUID2", "equals": "`todoorel`.`TableGUID`", "null_rejecting": false }, { "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "field": "GGUID", "equals": "`todoorel`.`TableGUID`", "null_rejecting": false }, { "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "field": "GGUID", "equals": "`rel`.`GUID2`", "null_rejecting": true }, { "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "field": "GGUID", "equals": "`rel`.`GUID2`", "null_rejecting": true }, { "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "field": "GGUID", "equals": "`todoorel`.`TableGUID`", "null_rejecting": false }, { "table": "`todoorel`", "field": "TableGUID", "equals": "`rel`.`GUID2`", "null_rejecting": true }, { "table": "`todoorel`", "field": "TableGUID", "equals": "`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID`", "null_rejecting": false }, { "table": "`todoorel`", "field": "TableGUID", "equals": "`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID`", "null_rejecting": false }, { "table": "`todoorel`", "field": "TableGUID", "equals": "`rel`.`GUID2`", "null_rejecting": true } ] }, { "pulled_out_semijoin_tables": [ ] }, { "rows_estimation": [ { "table": "`emailstore0` `emailstore`", "table_scan": { "rows": 114935, "cost": 5740 } }, { "table": "`emailstoreorel`", "range_analysis": { "table_scan": { "rows": 128240, "cost": 26517 }, "potential_range_indices": [ { "index": "PRIMARY", "usable": false, "cause": "not_applicable" }, { "index": "IDX_EMAILSTOREOREL_OID_EIMRole", "usable": true, "key_parts": [ "OID", "EIMRole", "GGUID" ] }, { "index": "IDX_EMORELTableGUID10", "usable": false, "cause": "not_applicable" }, { "index": "IDX_EMVORELOID9", "usable": true, "key_parts": [ "OID", "GGUID" ] }, { "index": "IX_MIXOREL_V517", "usable": false, "cause": "not_applicable" }, { "index": "IDX_EMAILSTOREORel_Role", "usable": true, "key_parts": [ "OID", "EIMRole", "TableGUID", "GGUID" ] }, { "index": "IDX_EMAILSTOREORel_Permission", "usable": true, "key_parts": [ "EIMRight", "OID", "TableGUID", "GGUID" ] } ], "best_covering_index_scan": { "index": "IDX_EMAILSTOREORel_Permission", "cost": 26275, "chosen": true }, "setup_range_conditions": [ ], "group_index_range": { "chosen": false, "cause": "not_single_table" }, "analyzing_range_alternatives": { "range_scan_alternatives": [ { "index": "IDX_EMAILSTOREOREL_OID_EIMRole", "ranges": [ "-431 <= OID <= -431", "-430 <= OID <= -430", "-428 <= OID <= -428", "-427 <= OID <= -427", "-426 <= OID <= -426", "-415 <= OID <= -415", "-396 <= OID <= -396", "-380 <= OID <= -380", "-366 <= OID <= -366", "-365 <= OID <= -365", "-357 <= OID <= -357", "-324 <= OID <= -324", "-323 <= OID <= -323", "-321 <= OID <= -321", "-320 <= OID <= -320", "-319 <= OID <= -319", "-317 <= OID <= -317", "-314 <= OID <= -314", "-313 <= OID <= -313", "-311 <= OID <= -311", "-309 <= OID <= -309", "-308 <= OID <= -308", "-307 <= OID <= -307", "-306 <= OID <= -306", "-305 <= OID <= -305", "-279 <= OID <= -279", "-270 <= OID <= -270", "-218 <= OID <= -218", "-217 <= OID <= -217", "-216 <= OID <= -216", "-215 <= OID <= -215", "-161 <= OID <= -161", "-159 <= OID <= -159", "-150 <= OID <= -150", "-149 <= OID <= -149", "-148 <= OID <= -148", "-110 <= OID <= -110", "-109 <= OID <= -109", "-107 <= OID <= -107", "-105 <= OID <= -105", "-103 <= OID <= -103", "-102 <= OID <= -102", "-101 <= OID <= -101", "-100 <= OID <= -100", "-99 <= OID <= -99", "-98 <= OID <= -98", "-95 <= OID <= -95", "-93 <= OID <= -93", "-92 <= OID <= -92", "-91 <= OID <= -91", "-90 <= OID <= -90", "-88 <= OID <= -88", "-50 <= OID <= -50", "-9 <= OID <= -9", "-8 <= OID <= -8", "0 <= OID <= 0", "996 <= OID <= 996", "997 <= OID <= 997", "999 <= OID <= 999", "1000 <= OID <= 1000", "1001 <= OID <= 1001", "1002 <= OID <= 1002", "1003 <= OID <= 1003", "1004 <= OID <= 1004", "1005 <= OID <= 1005", "1006 <= OID <= 1006", "1007 <= OID <= 1007", "1008 <= OID <= 1008", "1009 <= OID <= 1009", "1010 <= OID <= 1010", "1012 <= OID <= 1012", "1013 <= OID <= 1013", "1014 <= OID <= 1014", "1015 <= OID <= 1015", "1016 <= OID <= 1016", "1017 <= OID <= 1017", "1018 <= OID <= 1018", "1019 <= OID <= 1019", "1020 <= OID <= 1020", "1021 <= OID <= 1021", "1022 <= OID <= 1022", "1023 <= OID <= 1023", "1024 <= OID <= 1024", "1025 <= OID <= 1025", "1026 <= OID <= 1026", "1027 <= OID <= 1027", "1028 <= OID <= 1028", "1029 <= OID <= 1029", "1030 <= OID <= 1030", "1031 <= OID <= 1031", "1032 <= OID <= 1032", "1033 <= OID <= 1033", "1034 <= OID <= 1034", "3055 <= OID <= 3055", "3089 <= OID <= 3089", "3090 <= OID <= 3090", "3091 <= OID <= 3091", "3093 <= OID <= 3093", "3094 <= OID <= 3094", "3096 <= OID <= 3096", "3406 <= OID <= 3406", "3407 <= OID <= 3407", "3453 <= OID <= 3453", "3454 <= OID <= 3454", "3519 <= OID <= 3519", "3588 <= OID <= 3588", "3589 <= OID <= 3589", "3590 <= OID <= 3590", "3591 <= OID <= 3591", "3592 <= OID <= 3592", "3593 <= OID <= 3593", "3594 <= OID <= 3594", "3595 <= OID <= 3595", "3596 <= OID <= 3596", "3597 <= OID <= 3597", "3598 <= OID <= 3598", "3599 <= OID <= 3599", "3600 <= OID <= 3600", "3606 <= OID <= 3606", "3607 <= OID <= 3607", "3608 <= OID <= 3608", "3609 <= OID <= 3609", "3610 <= OID <= 3610", "3613 <= OID <= 3613", "3615 <= OID <= 3615", "3616 <= OID <= 3616", "3755 <= OID <= 3755", "3756 <= OID <= 3756", "3840 <= OID <= 3840", "3841 <= OID <= 3841", "3842 <= OID <= 3842", "3843 <= OID <= 3843", "3844 <= OID <= 3844", "3845 <= OID <= 3845", "3846 <= OID <= 3846", "3847 <= OID <= 3847", "3848 <= OID <= 3848", "3849 <= OID <= 3849", "3850 <= OID <= 3850", "3852 <= OID <= 3852", "3855 <= OID <= 3855", "3934 <= OID <= 3934", "3935 <= OID <= 3935", "3936 <= OID <= 3936", "3937 <= OID <= 3937", "3938 <= OID <= 3938", "3939 <= OID <= 3939", "3940 <= OID <= 3940", "3941 <= OID <= 3941", "3942 <= OID <= 3942", "3943 <= OID <= 3943", "3944 <= OID <= 3944", "3945 <= OID <= 3945", "3946 <= OID <= 3946", "3947 <= OID <= 3947", "4093 <= OID <= 4093", "4109 <= OID <= 4109", "4114 <= OID <= 4114", "4115 <= OID <= 4115", "4189 <= OID <= 4189", "4226 <= OID <= 4226", "4328 <= OID <= 4328", "4332 <= OID <= 4332", "4355 <= OID <= 4355", "4389 <= OID <= 4389", "4390 <= OID <= 4390", "4392 <= OID <= 4392", "4399 <= OID <= 4399", "4400 <= OID <= 4400", "4401 <= OID <= 4401", "4402 <= OID <= 4402", "4403 <= OID <= 4403", "4404 <= OID <= 4404", "4443 <= OID <= 4443", "4456 <= OID <= 4456", "4457 <= OID <= 4457", "4458 <= OID <= 4458", "4459 <= OID <= 4459", "4460 <= OID <= 4460", "4461 <= OID <= 4461", "4462 <= OID <= 4462", "4463 <= OID <= 4463", "4464 <= OID <= 4464", "4465 <= OID <= 4465", "4527 <= OID <= 4527", "4550 <= OID <= 4550" ], "index_dives_for_eq_ranges": false, "rowid_ordered": false, "using_mrr": false, "index_only": false, "rows": 40734, "cost": 49067, "chosen": false, "cause": "cost" }, { "index": "IDX_EMVORELOID9", "ranges": [ "-431 <= OID <= -431", "-430 <= OID <= -430", "-428 <= OID <= -428", "-427 <= OID <= -427", "-426 <= OID <= -426", "-415 <= OID <= -415", "-396 <= OID <= -396", "-380 <= OID <= -380", "-366 <= OID <= -366", "-365 <= OID <= -365", "-357 <= OID <= -357", "-324 <= OID <= -324", "-323 <= OID <= -323", "-321 <= OID <= -321", "-320 <= OID <= -320", "-319 <= OID <= -319", "-317 <= OID <= -317", "-314 <= OID <= -314", "-313 <= OID <= -313", "-311 <= OID <= -311", "-309 <= OID <= -309", "-308 <= OID <= -308", "-307 <= OID <= -307", "-306 <= OID <= -306", "-305 <= OID <= -305", "-279 <= OID <= -279", "-270 <= OID <= -270", "-218 <= OID <= -218", "-217 <= OID <= -217", "-216 <= OID <= -216", "-215 <= OID <= -215", "-161 <= OID <= -161", "-159 <= OID <= -159", "-150 <= OID <= -150", "-149 <= OID <= -149", "-148 <= OID <= -148", "-110 <= OID <= -110", "-109 <= OID <= -109", "-107 <= OID <= -107", "-105 <= OID <= -105", "-103 <= OID <= -103", "-102 <= OID <= -102", "-101 <= OID <= -101", "-100 <= OID <= -100", "-99 <= OID <= -99", "-98 <= OID <= -98", "-95 <= OID <= -95", "-93 <= OID <= -93", "-92 <= OID <= -92", "-91 <= OID <= -91", "-90 <= OID <= -90", "-88 <= OID <= -88", "-50 <= OID <= -50", "-9 <= OID <= -9", "-8 <= OID <= -8", "0 <= OID <= 0", "996 <= OID <= 996", "997 <= OID <= 997", "999 <= OID <= 999", "1000 <= OID <= 1000", "1001 <= OID <= 1001", "1002 <= OID <= 1002", "1003 <= OID <= 1003", "1004 <= OID <= 1004", "1005 <= OID <= 1005", "1006 <= OID <= 1006", "1007 <= OID <= 1007", "1008 <= OID <= 1008", "1009 <= OID <= 1009", "1010 <= OID <= 1010", "1012 <= OID <= 1012", "1013 <= OID <= 1013", "1014 <= OID <= 1014", "1015 <= OID <= 1015", "1016 <= OID <= 1016", "1017 <= OID <= 1017", "1018 <= OID <= 1018", "1019 <= OID <= 1019", "1020 <= OID <= 1020", "1021 <= OID <= 1021", "1022 <= OID <= 1022", "1023 <= OID <= 1023", "1024 <= OID <= 1024", "1025 <= OID <= 1025", "1026 <= OID <= 1026", "1027 <= OID <= 1027", "1028 <= OID <= 1028", "1029 <= OID <= 1029", "1030 <= OID <= 1030", "1031 <= OID <= 1031", "1032 <= OID <= 1032", "1033 <= OID <= 1033", "1034 <= OID <= 1034", "3055 <= OID <= 3055", "3089 <= OID <= 3089", "3090 <= OID <= 3090", "3091 <= OID <= 3091", "3093 <= OID <= 3093", "3094 <= OID <= 3094", "3096 <= OID <= 3096", "3406 <= OID <= 3406", "3407 <= OID <= 3407", "3453 <= OID <= 3453", "3454 <= OID <= 3454", "3519 <= OID <= 3519", "3588 <= OID <= 3588", "3589 <= OID <= 3589", "3590 <= OID <= 3590", "3591 <= OID <= 3591", "3592 <= OID <= 3592", "3593 <= OID <= 3593", "3594 <= OID <= 3594", "3595 <= OID <= 3595", "3596 <= OID <= 3596", "3597 <= OID <= 3597", "3598 <= OID <= 3598", "3599 <= OID <= 3599", "3600 <= OID <= 3600", "3606 <= OID <= 3606", "3607 <= OID <= 3607", "3608 <= OID <= 3608", "3609 <= OID <= 3609", "3610 <= OID <= 3610", "3613 <= OID <= 3613", "3615 <= OID <= 3615", "3616 <= OID <= 3616", "3755 <= OID <= 3755", "3756 <= OID <= 3756", "3840 <= OID <= 3840", "3841 <= OID <= 3841", "3842 <= OID <= 3842", "3843 <= OID <= 3843", "3844 <= OID <= 3844", "3845 <= OID <= 3845", "3846 <= OID <= 3846", "3847 <= OID <= 3847", "3848 <= OID <= 3848", "3849 <= OID <= 3849", "3850 <= OID <= 3850", "3852 <= OID <= 3852", "3855 <= OID <= 3855", "3934 <= OID <= 3934", "3935 <= OID <= 3935", "3936 <= OID <= 3936", "3937 <= OID <= 3937", "3938 <= OID <= 3938", "3939 <= OID <= 3939", "3940 <= OID <= 3940", "3941 <= OID <= 3941", "3942 <= OID <= 3942", "3943 <= OID <= 3943", "3944 <= OID <= 3944", "3945 <= OID <= 3945", "3946 <= OID <= 3946", "3947 <= OID <= 3947", "4093 <= OID <= 4093", "4109 <= OID <= 4109", "4114 <= OID <= 4114", "4115 <= OID <= 4115", "4189 <= OID <= 4189", "4226 <= OID <= 4226", "4328 <= OID <= 4328", "4332 <= OID <= 4332", "4355 <= OID <= 4355", "4389 <= OID <= 4389", "4390 <= OID <= 4390", "4392 <= OID <= 4392", "4399 <= OID <= 4399", "4400 <= OID <= 4400", "4401 <= OID <= 4401", "4402 <= OID <= 4402", "4403 <= OID <= 4403", "4404 <= OID <= 4404", "4443 <= OID <= 4443", "4456 <= OID <= 4456", "4457 <= OID <= 4457", "4458 <= OID <= 4458", "4459 <= OID <= 4459", "4460 <= OID <= 4460", "4461 <= OID <= 4461", "4462 <= OID <= 4462", "4463 <= OID <= 4463", "4464 <= OID <= 4464", "4465 <= OID <= 4465", "4527 <= OID <= 4527", "4550 <= OID <= 4550" ], "index_dives_for_eq_ranges": false, "rowid_ordered": false, "using_mrr": false, "index_only": false, "rows": 42966, "cost": 51745, "chosen": false, "cause": "cost" }, { "index": "IDX_EMAILSTOREORel_Role", "ranges": [ "-431 <= OID <= -431", "-430 <= OID <= -430", "-428 <= OID <= -428", "-427 <= OID <= -427", "-426 <= OID <= -426", "-415 <= OID <= -415", "-396 <= OID <= -396", "-380 <= OID <= -380", "-366 <= OID <= -366", "-365 <= OID <= -365", "-357 <= OID <= -357", "-324 <= OID <= -324", "-323 <= OID <= -323", "-321 <= OID <= -321", "-320 <= OID <= -320", "-319 <= OID <= -319", "-317 <= OID <= -317", "-314 <= OID <= -314", "-313 <= OID <= -313", "-311 <= OID <= -311", "-309 <= OID <= -309", "-308 <= OID <= -308", "-307 <= OID <= -307", "-306 <= OID <= -306", "-305 <= OID <= -305", "-279 <= OID <= -279", "-270 <= OID <= -270", "-218 <= OID <= -218", "-217 <= OID <= -217", "-216 <= OID <= -216", "-215 <= OID <= -215", "-161 <= OID <= -161", "-159 <= OID <= -159", "-150 <= OID <= -150", "-149 <= OID <= -149", "-148 <= OID <= -148", "-110 <= OID <= -110", "-109 <= OID <= -109", "-107 <= OID <= -107", "-105 <= OID <= -105", "-103 <= OID <= -103", "-102 <= OID <= -102", "-101 <= OID <= -101", "-100 <= OID <= -100", "-99 <= OID <= -99", "-98 <= OID <= -98", "-95 <= OID <= -95", "-93 <= OID <= -93", "-92 <= OID <= -92", "-91 <= OID <= -91", "-90 <= OID <= -90", "-88 <= OID <= -88", "-50 <= OID <= -50", "-9 <= OID <= -9", "-8 <= OID <= -8", "0 <= OID <= 0", "996 <= OID <= 996", "997 <= OID <= 997", "999 <= OID <= 999", "1000 <= OID <= 1000", "1001 <= OID <= 1001", "1002 <= OID <= 1002", "1003 <= OID <= 1003", "1004 <= OID <= 1004", "1005 <= OID <= 1005", "1006 <= OID <= 1006", "1007 <= OID <= 1007", "1008 <= OID <= 1008", "1009 <= OID <= 1009", "1010 <= OID <= 1010", "1012 <= OID <= 1012", "1013 <= OID <= 1013", "1014 <= OID <= 1014", "1015 <= OID <= 1015", "1016 <= OID <= 1016", "1017 <= OID <= 1017", "1018 <= OID <= 1018", "1019 <= OID <= 1019", "1020 <= OID <= 1020", "1021 <= OID <= 1021", "1022 <= OID <= 1022", "1023 <= OID <= 1023", "1024 <= OID <= 1024", "1025 <= OID <= 1025", "1026 <= OID <= 1026", "1027 <= OID <= 1027", "1028 <= OID <= 1028", "1029 <= OID <= 1029", "1030 <= OID <= 1030", "1031 <= OID <= 1031", "1032 <= OID <= 1032", "1033 <= OID <= 1033", "1034 <= OID <= 1034", "3055 <= OID <= 3055", "3089 <= OID <= 3089", "3090 <= OID <= 3090", "3091 <= OID <= 3091", "3093 <= OID <= 3093", "3094 <= OID <= 3094", "3096 <= OID <= 3096", "3406 <= OID <= 3406", "3407 <= OID <= 3407", "3453 <= OID <= 3453", "3454 <= OID <= 3454", "3519 <= OID <= 3519", "3588 <= OID <= 3588", "3589 <= OID <= 3589", "3590 <= OID <= 3590", "3591 <= OID <= 3591", "3592 <= OID <= 3592", "3593 <= OID <= 3593", "3594 <= OID <= 3594", "3595 <= OID <= 3595", "3596 <= OID <= 3596", "3597 <= OID <= 3597", "3598 <= OID <= 3598", "3599 <= OID <= 3599", "3600 <= OID <= 3600", "3606 <= OID <= 3606", "3607 <= OID <= 3607", "3608 <= OID <= 3608", "3609 <= OID <= 3609", "3610 <= OID <= 3610", "3613 <= OID <= 3613", "3615 <= OID <= 3615", "3616 <= OID <= 3616", "3755 <= OID <= 3755", "3756 <= OID <= 3756", "3840 <= OID <= 3840", "3841 <= OID <= 3841", "3842 <= OID <= 3842", "3843 <= OID <= 3843", "3844 <= OID <= 3844", "3845 <= OID <= 3845", "3846 <= OID <= 3846", "3847 <= OID <= 3847", "3848 <= OID <= 3848", "3849 <= OID <= 3849", "3850 <= OID <= 3850", "3852 <= OID <= 3852", "3855 <= OID <= 3855", "3934 <= OID <= 3934", "3935 <= OID <= 3935", "3936 <= OID <= 3936", "3937 <= OID <= 3937", "3938 <= OID <= 3938", "3939 <= OID <= 3939", "3940 <= OID <= 3940", "3941 <= OID <= 3941", "3942 <= OID <= 3942", "3943 <= OID <= 3943", "3944 <= OID <= 3944", "3945 <= OID <= 3945", "3946 <= OID <= 3946", "3947 <= OID <= 3947", "4093 <= OID <= 4093", "4109 <= OID <= 4109", "4114 <= OID <= 4114", "4115 <= OID <= 4115", "4189 <= OID <= 4189", "4226 <= OID <= 4226", "4328 <= OID <= 4328", "4332 <= OID <= 4332", "4355 <= OID <= 4355", "4389 <= OID <= 4389", "4390 <= OID <= 4390", "4392 <= OID <= 4392", "4399 <= OID <= 4399", "4400 <= OID <= 4400", "4401 <= OID <= 4401", "4402 <= OID <= 4402", "4403 <= OID <= 4403", "4404 <= OID <= 4404", "4443 <= OID <= 4443", "4456 <= OID <= 4456", "4457 <= OID <= 4457", "4458 <= OID <= 4458", "4459 <= OID <= 4459", "4460 <= OID <= 4460", "4461 <= OID <= 4461", "4462 <= OID <= 4462", "4463 <= OID <= 4463", "4464 <= OID <= 4464", "4465 <= OID <= 4465", "4527 <= OID <= 4527", "4550 <= OID <= 4550" ], "index_dives_for_eq_ranges": false, "rowid_ordered": false, "using_mrr": false, "index_only": false, "rows": 37200, "cost": 44826, "chosen": false, "cause": "cost" }, { "index": "IDX_EMAILSTOREORel_Permission", "ranges": [ "64 <= EIMRight" ], "index_dives_for_eq_ranges": true, "rowid_ordered": false, "using_mrr": false, "index_only": true, "rows": 64120, "cost": 13138, "chosen": true } ], "analyzing_roworder_intersect": { "usable": false, "cause": "too_few_roworder_scans" } }, "chosen_range_access_summary": { "range_access_plan": { "type": "range_scan", "index": "IDX_EMAILSTOREORel_Permission", "rows": 64120, "ranges": [ "64 <= EIMRight" ] }, "rows_for_plan": 64120, "cost_for_plan": 13138, "chosen": true } } }, { "table": "`tablerelation` `rel`", "table_scan": { "rows": 2862739, "cost": 30208 } }, { "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "table_scan": { "rows": 100156, "cost": 3945 } }, { "table": "`todoorel`", "range_analysis": { "table_scan": { "rows": 215344, "cost": 44579 }, "potential_range_indices": [ { "index": "PRIMARY", "usable": false, "cause": "not_applicable" }, { "index": "IDX_OID254", "usable": true, "key_parts": [ "OID", "GGUID" ] }, { "index": "IDX_TableGUID255", "usable": false, "cause": "not_applicable" }, { "index": "IDX_TODOOREL_OID_EIMRole", "usable": true, "key_parts": [ "OID", "EIMRole", "GGUID" ] }, { "index": "IX_MIXOREL_V510", "usable": false, "cause": "not_applicable" }, { "index": "IDX_TODOORel_Role", "usable": true, "key_parts": [ "OID", "EIMRole", "TableGUID", "GGUID" ] }, { "index": "IDX_TODOORel_Permission", "usable": true, "key_parts": [ "EIMRight", "OID", "TableGUID", "GGUID" ] } ], "best_covering_index_scan": { "index": "IDX_TODOORel_Permission", "cost": 44120, "chosen": true }, "setup_range_conditions": [ ], "group_index_range": { "chosen": false, "cause": "not_single_table" }, "analyzing_range_alternatives": { "range_scan_alternatives": [ { "index": "IDX_OID254", "ranges": [ "-431 <= OID <= -431", "-430 <= OID <= -430", "-428 <= OID <= -428", "-427 <= OID <= -427", "-426 <= OID <= -426", "-415 <= OID <= -415", "-396 <= OID <= -396", "-380 <= OID <= -380", "-366 <= OID <= -366", "-365 <= OID <= -365", "-357 <= OID <= -357", "-324 <= OID <= -324", "-323 <= OID <= -323", "-321 <= OID <= -321", "-320 <= OID <= -320", "-319 <= OID <= -319", "-317 <= OID <= -317", "-314 <= OID <= -314", "-313 <= OID <= -313", "-311 <= OID <= -311", "-309 <= OID <= -309", "-308 <= OID <= -308", "-307 <= OID <= -307", "-306 <= OID <= -306", "-305 <= OID <= -305", "-279 <= OID <= -279", "-270 <= OID <= -270", "-218 <= OID <= -218", "-217 <= OID <= -217", "-216 <= OID <= -216", "-215 <= OID <= -215", "-161 <= OID <= -161", "-159 <= OID <= -159", "-150 <= OID <= -150", "-149 <= OID <= -149", "-148 <= OID <= -148", "-110 <= OID <= -110", "-109 <= OID <= -109", "-107 <= OID <= -107", "-105 <= OID <= -105", "-103 <= OID <= -103", "-102 <= OID <= -102", "-101 <= OID <= -101", "-100 <= OID <= -100", "-99 <= OID <= -99", "-98 <= OID <= -98", "-95 <= OID <= -95", "-93 <= OID <= -93", "-92 <= OID <= -92", "-91 <= OID <= -91", "-90 <= OID <= -90", "-88 <= OID <= -88", "-50 <= OID <= -50", "-9 <= OID <= -9", "-8 <= OID <= -8", "0 <= OID <= 0", "996 <= OID <= 996", "997 <= OID <= 997", "999 <= OID <= 999", "1000 <= OID <= 1000", "1001 <= OID <= 1001", "1002 <= OID <= 1002", "1003 <= OID <= 1003", "1004 <= OID <= 1004", "1005 <= OID <= 1005", "1006 <= OID <= 1006", "1007 <= OID <= 1007", "1008 <= OID <= 1008", "1009 <= OID <= 1009", "1010 <= OID <= 1010", "1012 <= OID <= 1012", "1013 <= OID <= 1013", "1014 <= OID <= 1014", "1015 <= OID <= 1015", "1016 <= OID <= 1016", "1017 <= OID <= 1017", "1018 <= OID <= 1018", "1019 <= OID <= 1019", "1020 <= OID <= 1020", "1021 <= OID <= 1021", "1022 <= OID <= 1022", "1023 <= OID <= 1023", "1024 <= OID <= 1024", "1025 <= OID <= 1025", "1026 <= OID <= 1026", "1027 <= OID <= 1027", "1028 <= OID <= 1028", "1029 <= OID <= 1029", "1030 <= OID <= 1030", "1031 <= OID <= 1031", "1032 <= OID <= 1032", "1033 <= OID <= 1033", "1034 <= OID <= 1034", "3055 <= OID <= 3055", "3089 <= OID <= 3089", "3090 <= OID <= 3090", "3091 <= OID <= 3091", "3093 <= OID <= 3093", "3094 <= OID <= 3094", "3096 <= OID <= 3096", "3406 <= OID <= 3406", "3407 <= OID <= 3407", "3453 <= OID <= 3453", "3454 <= OID <= 3454", "3519 <= OID <= 3519", "3588 <= OID <= 3588", "3589 <= OID <= 3589", "3590 <= OID <= 3590", "3591 <= OID <= 3591", "3592 <= OID <= 3592", "3593 <= OID <= 3593", "3594 <= OID <= 3594", "3595 <= OID <= 3595", "3596 <= OID <= 3596", "3597 <= OID <= 3597", "3598 <= OID <= 3598", "3599 <= OID <= 3599", "3600 <= OID <= 3600", "3606 <= OID <= 3606", "3607 <= OID <= 3607", "3608 <= OID <= 3608", "3609 <= OID <= 3609", "3610 <= OID <= 3610", "3613 <= OID <= 3613", "3615 <= OID <= 3615", "3616 <= OID <= 3616", "3755 <= OID <= 3755", "3756 <= OID <= 3756", "3840 <= OID <= 3840", "3841 <= OID <= 3841", "3842 <= OID <= 3842", "3843 <= OID <= 3843", "3844 <= OID <= 3844", "3845 <= OID <= 3845", "3846 <= OID <= 3846", "3847 <= OID <= 3847", "3848 <= OID <= 3848", "3849 <= OID <= 3849", "3850 <= OID <= 3850", "3852 <= OID <= 3852", "3855 <= OID <= 3855", "3934 <= OID <= 3934", "3935 <= OID <= 3935", "3936 <= OID <= 3936", "3937 <= OID <= 3937", "3938 <= OID <= 3938", "3939 <= OID <= 3939", "3940 <= OID <= 3940", "3941 <= OID <= 3941", "3942 <= OID <= 3942", "3943 <= OID <= 3943", "3944 <= OID <= 3944", "3945 <= OID <= 3945", "3946 <= OID <= 3946", "3947 <= OID <= 3947", "4093 <= OID <= 4093", "4109 <= OID <= 4109", "4114 <= OID <= 4114", "4115 <= OID <= 4115", "4189 <= OID <= 4189", "4226 <= OID <= 4226", "4328 <= OID <= 4328", "4332 <= OID <= 4332", "4355 <= OID <= 4355", "4389 <= OID <= 4389", "4390 <= OID <= 4390", "4392 <= OID <= 4392", "4399 <= OID <= 4399", "4400 <= OID <= 4400", "4401 <= OID <= 4401", "4402 <= OID <= 4402", "4403 <= OID <= 4403", "4404 <= OID <= 4404", "4443 <= OID <= 4443", "4456 <= OID <= 4456", "4457 <= OID <= 4457", "4458 <= OID <= 4458", "4459 <= OID <= 4459", "4460 <= OID <= 4460", "4461 <= OID <= 4461", "4462 <= OID <= 4462", "4463 <= OID <= 4463", "4464 <= OID <= 4464", "4465 <= OID <= 4465", "4527 <= OID <= 4527", "4550 <= OID <= 4550" ], "index_dives_for_eq_ranges": false, "rowid_ordered": false, "using_mrr": false, "index_only": false, "rows": 71982, "cost": 86564, "chosen": false, "cause": "cost" }, { "index": "IDX_TODOOREL_OID_EIMRole", "ranges": [ "-431 <= OID <= -431", "-430 <= OID <= -430", "-428 <= OID <= -428", "-427 <= OID <= -427", "-426 <= OID <= -426", "-415 <= OID <= -415", "-396 <= OID <= -396", "-380 <= OID <= -380", "-366 <= OID <= -366", "-365 <= OID <= -365", "-357 <= OID <= -357", "-324 <= OID <= -324", "-323 <= OID <= -323", "-321 <= OID <= -321", "-320 <= OID <= -320", "-319 <= OID <= -319", "-317 <= OID <= -317", "-314 <= OID <= -314", "-313 <= OID <= -313", "-311 <= OID <= -311", "-309 <= OID <= -309", "-308 <= OID <= -308", "-307 <= OID <= -307", "-306 <= OID <= -306", "-305 <= OID <= -305", "-279 <= OID <= -279", "-270 <= OID <= -270", "-218 <= OID <= -218", "-217 <= OID <= -217", "-216 <= OID <= -216", "-215 <= OID <= -215", "-161 <= OID <= -161", "-159 <= OID <= -159", "-150 <= OID <= -150", "-149 <= OID <= -149", "-148 <= OID <= -148", "-110 <= OID <= -110", "-109 <= OID <= -109", "-107 <= OID <= -107", "-105 <= OID <= -105", "-103 <= OID <= -103", "-102 <= OID <= -102", "-101 <= OID <= -101", "-100 <= OID <= -100", "-99 <= OID <= -99", "-98 <= OID <= -98", "-95 <= OID <= -95", "-93 <= OID <= -93", "-92 <= OID <= -92", "-91 <= OID <= -91", "-90 <= OID <= -90", "-88 <= OID <= -88", "-50 <= OID <= -50", "-9 <= OID <= -9", "-8 <= OID <= -8", "0 <= OID <= 0", "996 <= OID <= 996", "997 <= OID <= 997", "999 <= OID <= 999", "1000 <= OID <= 1000", "1001 <= OID <= 1001", "1002 <= OID <= 1002", "1003 <= OID <= 1003", "1004 <= OID <= 1004", "1005 <= OID <= 1005", "1006 <= OID <= 1006", "1007 <= OID <= 1007", "1008 <= OID <= 1008", "1009 <= OID <= 1009", "1010 <= OID <= 1010", "1012 <= OID <= 1012", "1013 <= OID <= 1013", "1014 <= OID <= 1014", "1015 <= OID <= 1015", "1016 <= OID <= 1016", "1017 <= OID <= 1017", "1018 <= OID <= 1018", "1019 <= OID <= 1019", "1020 <= OID <= 1020", "1021 <= OID <= 1021", "1022 <= OID <= 1022", "1023 <= OID <= 1023", "1024 <= OID <= 1024", "1025 <= OID <= 1025", "1026 <= OID <= 1026", "1027 <= OID <= 1027", "1028 <= OID <= 1028", "1029 <= OID <= 1029", "1030 <= OID <= 1030", "1031 <= OID <= 1031", "1032 <= OID <= 1032", "1033 <= OID <= 1033", "1034 <= OID <= 1034", "3055 <= OID <= 3055", "3089 <= OID <= 3089", "3090 <= OID <= 3090", "3091 <= OID <= 3091", "3093 <= OID <= 3093", "3094 <= OID <= 3094", "3096 <= OID <= 3096", "3406 <= OID <= 3406", "3407 <= OID <= 3407", "3453 <= OID <= 3453", "3454 <= OID <= 3454", "3519 <= OID <= 3519", "3588 <= OID <= 3588", "3589 <= OID <= 3589", "3590 <= OID <= 3590", "3591 <= OID <= 3591", "3592 <= OID <= 3592", "3593 <= OID <= 3593", "3594 <= OID <= 3594", "3595 <= OID <= 3595", "3596 <= OID <= 3596", "3597 <= OID <= 3597", "3598 <= OID <= 3598", "3599 <= OID <= 3599", "3600 <= OID <= 3600", "3606 <= OID <= 3606", "3607 <= OID <= 3607", "3608 <= OID <= 3608", "3609 <= OID <= 3609", "3610 <= OID <= 3610", "3613 <= OID <= 3613", "3615 <= OID <= 3615", "3616 <= OID <= 3616", "3755 <= OID <= 3755", "3756 <= OID <= 3756", "3840 <= OID <= 3840", "3841 <= OID <= 3841", "3842 <= OID <= 3842", "3843 <= OID <= 3843", "3844 <= OID <= 3844", "3845 <= OID <= 3845", "3846 <= OID <= 3846", "3847 <= OID <= 3847", "3848 <= OID <= 3848", "3849 <= OID <= 3849", "3850 <= OID <= 3850", "3852 <= OID <= 3852", "3855 <= OID <= 3855", "3934 <= OID <= 3934", "3935 <= OID <= 3935", "3936 <= OID <= 3936", "3937 <= OID <= 3937", "3938 <= OID <= 3938", "3939 <= OID <= 3939", "3940 <= OID <= 3940", "3941 <= OID <= 3941", "3942 <= OID <= 3942", "3943 <= OID <= 3943", "3944 <= OID <= 3944", "3945 <= OID <= 3945", "3946 <= OID <= 3946", "3947 <= OID <= 3947", "4093 <= OID <= 4093", "4109 <= OID <= 4109", "4114 <= OID <= 4114", "4115 <= OID <= 4115", "4189 <= OID <= 4189", "4226 <= OID <= 4226", "4328 <= OID <= 4328", "4332 <= OID <= 4332", "4355 <= OID <= 4355", "4389 <= OID <= 4389", "4390 <= OID <= 4390", "4392 <= OID <= 4392", "4399 <= OID <= 4399", "4400 <= OID <= 4400", "4401 <= OID <= 4401", "4402 <= OID <= 4402", "4403 <= OID <= 4403", "4404 <= OID <= 4404", "4443 <= OID <= 4443", "4456 <= OID <= 4456", "4457 <= OID <= 4457", "4458 <= OID <= 4458", "4459 <= OID <= 4459", "4460 <= OID <= 4460", "4461 <= OID <= 4461", "4462 <= OID <= 4462", "4463 <= OID <= 4463", "4464 <= OID <= 4464", "4465 <= OID <= 4465", "4527 <= OID <= 4527", "4550 <= OID <= 4550" ], "index_dives_for_eq_ranges": false, "rowid_ordered": false, "using_mrr": false, "index_only": false, "rows": 33666, "cost": 40585, "chosen": true }, { "index": "IDX_TODOORel_Role", "ranges": [ "-431 <= OID <= -431", "-430 <= OID <= -430", "-428 <= OID <= -428", "-427 <= OID <= -427", "-426 <= OID <= -426", "-415 <= OID <= -415", "-396 <= OID <= -396", "-380 <= OID <= -380", "-366 <= OID <= -366", "-365 <= OID <= -365", "-357 <= OID <= -357", "-324 <= OID <= -324", "-323 <= OID <= -323", "-321 <= OID <= -321", "-320 <= OID <= -320", "-319 <= OID <= -319", "-317 <= OID <= -317", "-314 <= OID <= -314", "-313 <= OID <= -313", "-311 <= OID <= -311", "-309 <= OID <= -309", "-308 <= OID <= -308", "-307 <= OID <= -307", "-306 <= OID <= -306", "-305 <= OID <= -305", "-279 <= OID <= -279", "-270 <= OID <= -270", "-218 <= OID <= -218", "-217 <= OID <= -217", "-216 <= OID <= -216", "-215 <= OID <= -215", "-161 <= OID <= -161", "-159 <= OID <= -159", "-150 <= OID <= -150", "-149 <= OID <= -149", "-148 <= OID <= -148", "-110 <= OID <= -110", "-109 <= OID <= -109", "-107 <= OID <= -107", "-105 <= OID <= -105", "-103 <= OID <= -103", "-102 <= OID <= -102", "-101 <= OID <= -101", "-100 <= OID <= -100", "-99 <= OID <= -99", "-98 <= OID <= -98", "-95 <= OID <= -95", "-93 <= OID <= -93", "-92 <= OID <= -92", "-91 <= OID <= -91", "-90 <= OID <= -90", "-88 <= OID <= -88", "-50 <= OID <= -50", "-9 <= OID <= -9", "-8 <= OID <= -8", "0 <= OID <= 0", "996 <= OID <= 996", "997 <= OID <= 997", "999 <= OID <= 999", "1000 <= OID <= 1000", "1001 <= OID <= 1001", "1002 <= OID <= 1002", "1003 <= OID <= 1003", "1004 <= OID <= 1004", "1005 <= OID <= 1005", "1006 <= OID <= 1006", "1007 <= OID <= 1007", "1008 <= OID <= 1008", "1009 <= OID <= 1009", "1010 <= OID <= 1010", "1012 <= OID <= 1012", "1013 <= OID <= 1013", "1014 <= OID <= 1014", "1015 <= OID <= 1015", "1016 <= OID <= 1016", "1017 <= OID <= 1017", "1018 <= OID <= 1018", "1019 <= OID <= 1019", "1020 <= OID <= 1020", "1021 <= OID <= 1021", "1022 <= OID <= 1022", "1023 <= OID <= 1023", "1024 <= OID <= 1024", "1025 <= OID <= 1025", "1026 <= OID <= 1026", "1027 <= OID <= 1027", "1028 <= OID <= 1028", "1029 <= OID <= 1029", "1030 <= OID <= 1030", "1031 <= OID <= 1031", "1032 <= OID <= 1032", "1033 <= OID <= 1033", "1034 <= OID <= 1034", "3055 <= OID <= 3055", "3089 <= OID <= 3089", "3090 <= OID <= 3090", "3091 <= OID <= 3091", "3093 <= OID <= 3093", "3094 <= OID <= 3094", "3096 <= OID <= 3096", "3406 <= OID <= 3406", "3407 <= OID <= 3407", "3453 <= OID <= 3453", "3454 <= OID <= 3454", "3519 <= OID <= 3519", "3588 <= OID <= 3588", "3589 <= OID <= 3589", "3590 <= OID <= 3590", "3591 <= OID <= 3591", "3592 <= OID <= 3592", "3593 <= OID <= 3593", "3594 <= OID <= 3594", "3595 <= OID <= 3595", "3596 <= OID <= 3596", "3597 <= OID <= 3597", "3598 <= OID <= 3598", "3599 <= OID <= 3599", "3600 <= OID <= 3600", "3606 <= OID <= 3606", "3607 <= OID <= 3607", "3608 <= OID <= 3608", "3609 <= OID <= 3609", "3610 <= OID <= 3610", "3613 <= OID <= 3613", "3615 <= OID <= 3615", "3616 <= OID <= 3616", "3755 <= OID <= 3755", "3756 <= OID <= 3756", "3840 <= OID <= 3840", "3841 <= OID <= 3841", "3842 <= OID <= 3842", "3843 <= OID <= 3843", "3844 <= OID <= 3844", "3845 <= OID <= 3845", "3846 <= OID <= 3846", "3847 <= OID <= 3847", "3848 <= OID <= 3848", "3849 <= OID <= 3849", "3850 <= OID <= 3850", "3852 <= OID <= 3852", "3855 <= OID <= 3855", "3934 <= OID <= 3934", "3935 <= OID <= 3935", "3936 <= OID <= 3936", "3937 <= OID <= 3937", "3938 <= OID <= 3938", "3939 <= OID <= 3939", "3940 <= OID <= 3940", "3941 <= OID <= 3941", "3942 <= OID <= 3942", "3943 <= OID <= 3943", "3944 <= OID <= 3944", "3945 <= OID <= 3945", "3946 <= OID <= 3946", "3947 <= OID <= 3947", "4093 <= OID <= 4093", "4109 <= OID <= 4109", "4114 <= OID <= 4114", "4115 <= OID <= 4115", "4189 <= OID <= 4189", "4226 <= OID <= 4226", "4328 <= OID <= 4328", "4332 <= OID <= 4332", "4355 <= OID <= 4355", "4389 <= OID <= 4389", "4390 <= OID <= 4390", "4392 <= OID <= 4392", "4399 <= OID <= 4399", "4400 <= OID <= 4400", "4401 <= OID <= 4401", "4402 <= OID <= 4402", "4403 <= OID <= 4403", "4404 <= OID <= 4404", "4443 <= OID <= 4443", "4456 <= OID <= 4456", "4457 <= OID <= 4457", "4458 <= OID <= 4458", "4459 <= OID <= 4459", "4460 <= OID <= 4460", "4461 <= OID <= 4461", "4462 <= OID <= 4462", "4463 <= OID <= 4463", "4464 <= OID <= 4464", "4465 <= OID <= 4465", "4527 <= OID <= 4527", "4550 <= OID <= 4550" ], "index_dives_for_eq_ranges": false, "rowid_ordered": false, "using_mrr": false, "index_only": false, "rows": 54870, "cost": 66030, "chosen": false, "cause": "cost" }, { "index": "IDX_TODOORel_Permission", "ranges": [ "64 <= EIMRight" ], "index_dives_for_eq_ranges": true, "rowid_ordered": false, "using_mrr": false, "index_only": true, "rows": 107672, "cost": 22061, "chosen": true } ], "analyzing_roworder_intersect": { "usable": false, "cause": "too_few_roworder_scans" } }, "chosen_range_access_summary": { "range_access_plan": { "type": "range_scan", "index": "IDX_TODOORel_Permission", "rows": 107672, "ranges": [ "64 <= EIMRight" ] }, "rows_for_plan": 107672, "cost_for_plan": 22061, "chosen": true } } } ] }, { "execution_plan_for_potential_materialization": { "steps": [ ] } }, { "execution_plan_for_potential_materialization": { "steps": [ { "considered_execution_plans": [ { "plan_prefix": [ ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "usable": false, "chosen": false }, { "access_type": "scan", "rows": 100156, "cost": 23976, "chosen": true } ] }, "cost_for_plan": 23976, "rows_for_plan": 100156, "rest_of_plan": [ { "plan_prefix": [ "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "rows": 1, "cost": 100156, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "rows": 1, "cost": 100156, "chosen": false }, { "access_type": "range", "rows": 33666, "cost": 4.37e9, "chosen": false } ] }, "cost_for_plan": 144163, "rows_for_plan": 100156, "rest_of_plan": [ { "plan_prefix": [ "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`todoorel`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 100156, "chosen": true }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 100156, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "added_to_eq_ref_extension": true, "cost_for_plan": 264351, "rows_for_plan": 100156, "sort_cost": 100156, "new_cost_for_plan": 364507, "chosen": true } ] } ] }, { "plan_prefix": [ ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "usable": false, "chosen": false }, { "access_type": "range", "rows": 33666, "cost": 43595, "chosen": true } ] }, "cost_for_plan": 43595, "rows_for_plan": 33666, "rest_of_plan": [ { "plan_prefix": [ "`todoorel`" ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 33666, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 33666, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 75117, "cost": 5.06e8, "chosen": false } ] }, "cost_for_plan": 83994, "rows_for_plan": 33666, "rest_of_plan": [ { "plan_prefix": [ "`todoorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 33666, "chosen": true }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 33666, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "added_to_eq_ref_extension": true, "cost_for_plan": 124393, "rows_for_plan": 33666, "sort_cost": 33666, "new_cost_for_plan": 158059, "chosen": true } ] } ] }, { "plan_prefix": [ ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IDX_GUID2297", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "usable": false, "chosen": false }, { "access_type": "scan", "rows": 2.86e6, "cost": 602756, "chosen": true } ] }, "cost_for_plan": 602756, "rows_for_plan": 2.86e6, "pruned_by_cost": true } ] } ] } }, { "considered_execution_plans": [ { "plan_prefix": [ ], "table": "`emailstoreorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_EMORELTableGUID10", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIXOREL_V517", "usable": false, "chosen": false }, { "access_type": "range", "rows": 37200, "cost": 25962, "chosen": true } ] }, "cost_for_plan": 25962, "rows_for_plan": 37200, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`" ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "usable": false, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 100156, "cost": 7.45e8, "chosen": true } ] }, "cost_for_plan": 7.45e8, "rows_for_plan": 3.73e9, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "rows": 1, "cost": 3.73e9, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "rows": 1, "cost": 3.73e9, "chosen": false }, { "access_type": "range", "rows": 33666, "cost": 1.6e14, "chosen": false } ] }, "cost_for_plan": 5.22e9, "rows_for_plan": 3.73e9, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`todoorel`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 37200, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 37200, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 86202, "cost": 6.4e13, "chosen": false } ] }, "added_to_eq_ref_extension": false }, { "plan_prefix": [ "`emailstoreorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`todoorel`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 2, "cost": 7.45e9, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 3.73e9, "chosen": true }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 3.88e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 3.73e9, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "added_to_eq_ref_extension": true, "cost_for_plan": 9.69e9, "rows_for_plan": 3.73e9, "semijoin_strategy_choice": [ { "strategy": "MaterializeScan", "choice": "deferred" } ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`todoorel`", "`tablerelation` `rel`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 37200, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 37200, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 86202, "cost": 6.4e13, "chosen": false } ] }, "added_to_eq_ref_extension": false }, { "plan_prefix": [ "`emailstoreorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`todoorel`", "`tablerelation` `rel`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 37200, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 37200, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 86202, "cost": 6.4e13, "chosen": false } ] }, "cost_for_plan": 1e10, "rows_for_plan": 3.73e9, "semijoin_strategy_choice": [ { "strategy": "MaterializeScan", "recalculate_access_paths_and_cost": { "tables": [ { "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 37200, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 37200, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 86202, "cost": 2.2e13, "chosen": false } ] } } ] }, "cost": 5.01e8, "rows": 37200, "duplicate_tables_left": true, "chosen": true }, { "strategy": "DuplicatesWeedout", "cost": 1.1e10, "rows": 1, "duplicate_tables_left": true, "chosen": true } ], "sort_cost": 1, "new_cost_for_plan": 1.1e10, "chosen": true } ] } ] }, { "plan_prefix": [ "`emailstoreorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 37200, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 37200, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 86202, "cost": 6.4e13, "chosen": false } ] }, "cost_for_plan": 1.49e9, "rows_for_plan": 3.73e9, "semijoin_strategy_choice": [ ], "pruned_by_eq_ref_heuristic": true } ] }, { "plan_prefix": [ "`emailstoreorel`" ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "usable": false, "chosen": false }, { "access_type": "range", "rows": 33666, "cost": 1.62e9, "chosen": true } ] }, "cost_for_plan": 1.62e9, "rows_for_plan": 1.25e9, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todoorel`" ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 33666, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 33666, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 75117, "cost": 1.9e13, "chosen": false } ] }, "cost_for_plan": 1.87e9, "rows_for_plan": 1.25e9, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todoorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 37200, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 37200, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 86202, "cost": 2.2e13, "chosen": false } ] }, "added_to_eq_ref_extension": false }, { "plan_prefix": [ "`emailstoreorel`", "`todoorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 2, "cost": 2.5e9, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 1.25e9, "chosen": true }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 1.3e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 1.25e9, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "added_to_eq_ref_extension": false }, { "plan_prefix": [ "`emailstoreorel`", "`todoorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 37200, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 37200, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 86202, "cost": 2.2e13, "chosen": false } ] }, "cost_for_plan": 2.12e9, "rows_for_plan": 1.25e9, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todoorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`emailstore0` `emailstore`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 2, "cost": 2.5e9, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 1.25e9, "chosen": true }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 1.3e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 1.25e9, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "added_to_eq_ref_extension": false }, { "plan_prefix": [ "`emailstoreorel`", "`todoorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`emailstore0` `emailstore`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 2, "cost": 2.5e9, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 1.25e9, "chosen": true }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 1.3e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 1.25e9, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 3.63e9, "rows_for_plan": 1.25e9, "semijoin_strategy_choice": [ { "strategy": "DuplicatesWeedout", "cost": 3.88e9, "rows": 1, "duplicate_tables_left": true, "chosen": true } ], "sort_cost": 1, "new_cost_for_plan": 3.88e9, "chosen": true } ] }, { "plan_prefix": [ "`emailstoreorel`", "`todoorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 2, "cost": 2.5e9, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 1.25e9, "chosen": true }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 1.3e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 1.25e9, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 3.38e9, "rows_for_plan": 1.25e9, "semijoin_strategy_choice": [ { "strategy": "MaterializeScan", "choice": "deferred" } ], "pruned_by_heuristic": true } ] }, { "plan_prefix": [ "`emailstoreorel`", "`todoorel`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 37200, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 37200, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 86202, "cost": 2.2e13, "chosen": false } ] }, "cost_for_plan": 1.87e9, "rows_for_plan": 1.25e9, "semijoin_strategy_choice": [ ], "pruned_by_heuristic": true }, { "plan_prefix": [ "`emailstoreorel`", "`todoorel`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 2, "cost": 2.5e9, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 1.25e9, "chosen": true }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 1.3e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 1.25e9, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 3.12e9, "rows_for_plan": 1.25e9, "semijoin_strategy_choice": [ ], "pruned_by_heuristic": true } ] }, { "plan_prefix": [ "`emailstoreorel`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 37200, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 37200, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 86202, "cost": 6.41e8, "chosen": false } ] }, "cost_for_plan": 70602, "rows_for_plan": 37200, "semijoin_strategy_choice": [ { "strategy": "DuplicatesWeedout", "cost": 78044, "rows": 1, "duplicate_tables_left": true, "chosen": true } ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`" ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "usable": false, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 100156, "cost": 24004, "chosen": true } ] }, "added_to_eq_ref_extension": false }, { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`" ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "usable": false, "chosen": false }, { "access_type": "range", "rows": 33666, "cost": 43595, "chosen": true } ] }, "added_to_eq_ref_extension": false }, { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 2, "cost": 2.4, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 1.4417, "chosen": true }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "usable": false, "chosen": false }, { "access_type": "scan", "cost": 602756, "rows": 2862739, "cause": "cost", "chosen": false } ] }, "added_to_eq_ref_extension": false }, { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`" ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "usable": false, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 100156, "cost": 24004, "chosen": true } ] }, "cost_for_plan": 102048, "rows_for_plan": 100156, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "rows": 1, "cost": 100156, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "rows": 1, "cost": 100156, "chosen": false }, { "access_type": "range", "rows": 33666, "cost": 4.37e9, "chosen": false } ] }, "cost_for_plan": 222235, "rows_for_plan": 100156, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`todoorel`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 2, "cost": 200312, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 100156, "chosen": true }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 104330, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 100156, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "added_to_eq_ref_extension": true, "cost_for_plan": 342422, "rows_for_plan": 100156, "semijoin_strategy_choice": [ { "strategy": "FirstMatch", "recalculate_access_paths_and_cost": { "tables": [ { "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "usable": false, "chosen": false }, { "access_type": "scan", "rows": 100156, "cost": 23976, "chosen": true } ] } } ] }, "cost": 342395, "rows": 1, "chosen": true }, { "strategy": "MaterializeLookup", "cost": 209173, "rows": 1, "duplicate_tables_left": false, "chosen": true }, { "strategy": "DuplicatesWeedout", "cost": 2.98e9, "rows": 1, "duplicate_tables_left": false, "chosen": false } ], "sort_cost": 1, "new_cost_for_plan": 209174, "chosen": true } ] } ] }, { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`" ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "usable": false, "chosen": false }, { "access_type": "range", "rows": 33666, "cost": 43595, "chosen": true } ] }, "cost_for_plan": 121639, "rows_for_plan": 33666, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`", "`todoorel`" ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 33666, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 33666, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 75117, "cost": 5.07e8, "chosen": false } ] }, "cost_for_plan": 162038, "rows_for_plan": 33666, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`", "`todoorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 2, "cost": 67332, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 33666, "chosen": true }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 35069, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 33666, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "added_to_eq_ref_extension": true, "cost_for_plan": 202437, "rows_for_plan": 33666, "semijoin_strategy_choice": [ { "strategy": "FirstMatch", "recalculate_access_paths_and_cost": { "tables": [ { "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "usable": false, "chosen": false }, { "access_type": "range", "rows": 33666, "cost": 43595, "chosen": true } ] } } ] }, "cost": 202437, "rows": 1, "chosen": true }, { "strategy": "MaterializeLookup", "cost": 209173, "rows": 1, "duplicate_tables_left": false, "chosen": false }, { "strategy": "DuplicatesWeedout", "cost": 1e9, "rows": 1, "duplicate_tables_left": false, "chosen": false } ], "sort_cost": 1, "new_cost_for_plan": 202438, "chosen": true } ] } ] }, { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 2, "cost": 2.4, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 1.4417, "chosen": true }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "usable": false, "chosen": false }, { "access_type": "scan", "cost": 602756, "rows": 2862739, "cause": "cost", "chosen": false } ] }, "cost_for_plan": 78045, "rows_for_plan": 2, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`", "`tablerelation` `rel`" ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 74400, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 74400, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 75117, "cost": 39056, "chosen": true } ] }, "cost_for_plan": 117101, "rows_for_plan": 150234, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`", "`tablerelation` `rel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "rows": 1, "cost": 150234, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "rows": 1, "cost": 150234, "chosen": false }, { "access_type": "range", "rows": 33666, "cost": 6.55e9, "chosen": false } ] }, "cost_for_plan": 297382, "rows_for_plan": 150234, "semijoin_strategy_choice": [ { "strategy": "FirstMatch", "recalculate_access_paths_and_cost": { "tables": [ { "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 74400, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 74400, "chosen": false }, { "access_type": "scan", "rows": 75117, "cost": 47952, "chosen": true } ] } } ] }, "cost": 306279, "rows": 1, "chosen": true }, { "strategy": "MaterializeLookup", "cost": 209173, "rows": 1, "duplicate_tables_left": false, "chosen": true }, { "strategy": "DuplicatesWeedout", "cost": 3.35e9, "rows": 1, "duplicate_tables_left": false, "chosen": false } ], "pruned_by_cost": true } ] }, { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`", "`tablerelation` `rel`" ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "rows": 1, "cost": 2.2, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "rows": 1, "cost": 2.2, "chosen": false }, { "access_type": "range", "cost": 43594, "rows": 107672, "cause": "cost", "chosen": false } ] }, "cost_for_plan": 78048, "rows_for_plan": 2, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`", "`tablerelation` `rel`", "`todoorel`" ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 74400, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 74400, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 75117, "cost": 39056, "chosen": true } ] }, "added_to_eq_ref_extension": false }, { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`", "`tablerelation` `rel`", "`todoorel`" ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 74400, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 74400, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 75117, "cost": 39056, "chosen": true } ] }, "cost_for_plan": 117104, "rows_for_plan": 150234, "semijoin_strategy_choice": [ { "strategy": "FirstMatch", "recalculate_access_paths_and_cost": { "tables": [ { "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 74400, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 74400, "chosen": false }, { "access_type": "scan", "rows": 75117, "cost": 47952, "chosen": true } ] } } ] }, "cost": 126000, "rows": 1, "chosen": true }, { "strategy": "MaterializeLookup", "cost": 209173, "rows": 1, "duplicate_tables_left": false, "chosen": false }, { "strategy": "DuplicatesWeedout", "cost": 2.24e9, "rows": 1, "duplicate_tables_left": false, "chosen": false } ], "sort_cost": 1, "new_cost_for_plan": 126001, "chosen": true } ] } ] } ] }, { "plan_prefix": [ "`emailstoreorel`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 2, "cost": 74400, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 38750, "chosen": true }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "usable": false, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 79592, "rows_for_plan": 74400, "semijoin_strategy_choice": [ ], "pruned_by_heuristic": true } ] }, { "plan_prefix": [ ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "usable": false, "chosen": false }, { "access_type": "scan", "rows": 100156, "cost": 23976, "chosen": true } ] }, "cost_for_plan": 23976, "rows_for_plan": 100156, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`emailstoreorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_EMORELTableGUID10", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIXOREL_V517", "usable": false, "chosen": false }, { "access_type": "range", "rows": 37200, "cost": 2.6e9, "chosen": true } ] }, "cost_for_plan": 2.6e9, "rows_for_plan": 3.73e9, "semijoin_strategy_choice": [ ], "pruned_by_cost": true }, { "plan_prefix": [ "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "rows": 1, "cost": 100156, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "rows": 1, "cost": 100156, "chosen": false }, { "access_type": "range", "rows": 33666, "cost": 4.37e9, "chosen": false } ] }, "cost_for_plan": 144163, "rows_for_plan": 100156, "semijoin_strategy_choice": [ ], "pruned_by_cost": true }, { "plan_prefix": [ "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "usable": false, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 114935, "cost": 2.3e9, "chosen": true } ] }, "cost_for_plan": 2.3e9, "rows_for_plan": 1.2e10, "semijoin_strategy_choice": [ ], "pruned_by_cost": true }, { "plan_prefix": [ "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 100156, "chosen": true }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 100156, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 144163, "rows_for_plan": 100156, "semijoin_strategy_choice": [ ], "pruned_by_cost": true } ] }, { "plan_prefix": [ ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "usable": false, "chosen": false }, { "access_type": "range", "rows": 33666, "cost": 43595, "chosen": true } ] }, "cost_for_plan": 43595, "rows_for_plan": 33666, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`todoorel`" ], "table": "`emailstoreorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_EMORELTableGUID10", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIXOREL_V517", "usable": false, "chosen": false }, { "access_type": "range", "rows": 37200, "cost": 8.74e8, "chosen": true } ] }, "cost_for_plan": 8.74e8, "rows_for_plan": 1.25e9, "semijoin_strategy_choice": [ ], "pruned_by_cost": true }, { "plan_prefix": [ "`todoorel`" ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 33666, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 33666, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 75117, "cost": 5.06e8, "chosen": false } ] }, "cost_for_plan": 83994, "rows_for_plan": 33666, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`todoorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`emailstoreorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_EMORELTableGUID10", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIXOREL_V517", "usable": false, "chosen": false }, { "access_type": "range", "rows": 37200, "cost": 8.74e8, "chosen": true } ] }, "added_to_eq_ref_extension": false }, { "plan_prefix": [ "`todoorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "usable": false, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 114935, "cost": 7.74e8, "chosen": true } ] }, "added_to_eq_ref_extension": false }, { "plan_prefix": [ "`todoorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 33666, "chosen": true }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 33666, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "added_to_eq_ref_extension": true, "cost_for_plan": 124393, "rows_for_plan": 33666, "semijoin_strategy_choice": [ { "strategy": "MaterializeScan", "choice": "deferred" } ], "rest_of_plan": [ { "plan_prefix": [ "`todoorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`tablerelation` `rel`" ], "table": "`emailstoreorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_EMORELTableGUID10", "rows": 1, "cost": 33666, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V517", "rows": 1, "cost": 33666, "chosen": false }, { "access_type": "range", "rows": 37200, "cost": 8.74e8, "chosen": false } ] }, "added_to_eq_ref_extension": true, "cost_for_plan": 164793, "rows_for_plan": 33666, "semijoin_strategy_choice": [ ], "pruned_by_cost": true }, { "plan_prefix": [ "`todoorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`tablerelation` `rel`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 33666, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 33666, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 86202, "cost": 5.81e8, "chosen": false } ] }, "added_to_eq_ref_extension": true, "cost_for_plan": 164793, "rows_for_plan": 33666, "semijoin_strategy_choice": [ { "strategy": "MaterializeScan", "recalculate_access_paths_and_cost": { "tables": [ { "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 33666, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 33666, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 86202, "cost": 5.81e8, "chosen": false } ] } } ] }, "cost": 178261, "rows": 1, "duplicate_tables_left": true, "chosen": true }, { "strategy": "DuplicatesWeedout", "cost": 171528, "rows": 1, "duplicate_tables_left": false, "chosen": true } ], "pruned_by_cost": true }, { "plan_prefix": [ "`todoorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`tablerelation` `rel`" ], "table": "`emailstoreorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_EMORELTableGUID10", "rows": 1, "cost": 33666, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V517", "rows": 1, "cost": 33666, "chosen": false }, { "access_type": "range", "rows": 37200, "cost": 8.74e8, "chosen": false } ] }, "cost_for_plan": 164793, "rows_for_plan": 33666, "semijoin_strategy_choice": [ ], "pruned_by_cost": true }, { "plan_prefix": [ "`todoorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`tablerelation` `rel`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 33666, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 33666, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 86202, "cost": 5.81e8, "chosen": false } ] }, "cost_for_plan": 164793, "rows_for_plan": 33666, "semijoin_strategy_choice": [ { "strategy": "MaterializeScan", "recalculate_access_paths_and_cost": { "tables": [ { "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 33666, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 33666, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 86202, "cost": 5.81e8, "chosen": false } ] } } ] }, "cost": 178261, "rows": 1, "duplicate_tables_left": true, "chosen": true }, { "strategy": "DuplicatesWeedout", "cost": 171528, "rows": 1, "duplicate_tables_left": false, "chosen": true } ], "pruned_by_cost": true } ] } ] }, { "plan_prefix": [ "`todoorel`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "usable": false, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 114935, "cost": 7.74e8, "chosen": true } ] }, "cost_for_plan": 7.74e8, "rows_for_plan": 3.87e9, "semijoin_strategy_choice": [ ], "pruned_by_cost": true } ] }, { "plan_prefix": [ ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "usable": false, "chosen": false }, { "access_type": "scan", "rows": 114935, "cost": 28727, "chosen": true } ] }, "cost_for_plan": 28727, "rows_for_plan": 114935, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstore0` `emailstore`" ], "table": "`emailstoreorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_EMORELTableGUID10", "rows": 1, "cost": 114935, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V517", "rows": 1, "cost": 114935, "chosen": false }, { "access_type": "range", "rows": 37200, "cost": 2.98e9, "chosen": false } ] }, "cost_for_plan": 166649, "rows_for_plan": 114935, "semijoin_strategy_choice": [ { "strategy": "FirstMatch", "recalculate_access_paths_and_cost": { "tables": [ ] }, "cost": 166649, "rows": 114935, "chosen": true }, { "strategy": "DuplicatesWeedout", "cost": 212625, "rows": 114935, "duplicate_tables_left": false, "chosen": false } ], "pruned_by_cost": true }, { "plan_prefix": [ "`emailstore0` `emailstore`" ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "usable": false, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 100156, "cost": 2.31e9, "chosen": true } ] }, "cost_for_plan": 2.31e9, "rows_for_plan": 1.2e10, "semijoin_strategy_choice": [ ], "pruned_by_cost": true }, { "plan_prefix": [ "`emailstore0` `emailstore`" ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "usable": false, "chosen": false }, { "access_type": "range", "rows": 33666, "cost": 5.01e9, "chosen": true } ] }, "cost_for_plan": 5.01e9, "rows_for_plan": 3.87e9, "semijoin_strategy_choice": [ ], "pruned_by_cost": true }, { "plan_prefix": [ "`emailstore0` `emailstore`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 2, "cost": 229870, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 119724, "chosen": true }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "usable": false, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 194425, "rows_for_plan": 229870, "semijoin_strategy_choice": [ ], "pruned_by_cost": true } ] }, { "plan_prefix": [ ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 2e308, "cost": 0, "chosen": false }, { "access_type": "ref", "index": "IDX_GUID2297", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2e308, "cost": 0, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "usable": false, "chosen": false }, { "access_type": "scan", "rows": 2.86e6, "cost": 602756, "chosen": true } ] }, "cost_for_plan": 602756, "rows_for_plan": 2.86e6, "semijoin_strategy_choice": [ ], "pruned_by_cost": true }, { "final_semijoin_strategy": "FirstMatch", "recalculate_access_paths_and_cost": { "tables": [ { "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 1.2, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 1.2, "chosen": false }, { "access_type": "scan", "cost": 23976, "rows": 100156, "cause": "cost", "chosen": false } ] } } ] } }, { "final_semijoin_strategy": "DuplicateWeedout" } ] }, { "attaching_conditions_to_tables": { "original_condition": "((`todoorel`.`TableGUID` = `rel`.`GUID2`) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID` = `rel`.`GUID2`) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsTemplate` = 0) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsDeleted` = 0) and (`emailstore`.`GGUID` = `emailstoreorel`.`TableGUID`) and (`rel`.`GUID1` = `emailstoreorel`.`TableGUID`) and (`emailstore`.`IsTemplate` = 0) and (`emailstore`.`IsDeleted` = 0) and (`emailstoreorel`.`EIMRight` >= 64) and ((`emailstoreorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`emailstore`.`ForeignEditPermission` = 65535) and (`emailstoreorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`KEYWORD` like '%antragsanforderung%') and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`WORKINGPERCENT` = '100') and (`todoorel`.`EIMRight` >= 64) and ((`todoorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`ForeignEditPermission` = 65535) and (`todoorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))))))", "attached_conditions_computation": [ { "table": "`emailstoreorel`", "rechecking_index_usage": { "recheck_reason": "low_limit", "limit": 100, "row_estimate": 37200 } } ], "attached_conditions_summary": [ { "table": "`emailstoreorel`", "attached": "((`emailstoreorel`.`EIMRight` >= 64) and ((`emailstoreorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or (`emailstoreorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9)))))" }, { "table": "`emailstore0` `emailstore`", "attached": "((`emailstore`.`IsTemplate` = 0) and (`emailstore`.`IsDeleted` = 0) and ((`emailstoreorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`emailstore`.`ForeignEditPermission` = 65535) and (`emailstoreorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))))))" }, { "table": "`tablerelation` `rel`", "attached": "(`rel`.`GUID2` is not null)" }, { "table": "`todoorel`", "attached": "((`todoorel`.`EIMRight` >= 64) and ((`todoorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or (`todoorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9)))))" }, { "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "attached": "((`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsTemplate` = 0) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsDeleted` = 0) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`KEYWORD` like '%antragsanforderung%') and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`WORKINGPERCENT` = '100') and ((`todoorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`ForeignEditPermission` = 65535) and (`todoorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))))))" } ] } }, { "clause_processing": { "clause": "ORDER BY", "original_clause": "`emailstore`.`SendDate` desc,`emailstore`.`GGUID`", "items": [ { "item": "`emailstore`.`SendDate`" }, { "item": "`emailstore`.`GGUID`" } ], "resulting_clause_is_simple": false, "resulting_clause": "`emailstore`.`SendDate` desc,`emailstore`.`GGUID`" } }, { "refine_plan": [ { "creating_tmp_table": { "tmp_table_info": { "row_length": 18, "key_length": 16, "unique_constraint": false, "location": "memory (heap)", "row_limit_estimate": 932067 } } }, { "table": "`emailstoreorel`", "access_type": "range" }, { "table": "`emailstore0` `emailstore`" }, { "table": "`tablerelation` `rel`" }, { "table": "`todoorel`" }, { "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" } ] } ] } }, { "join_execution": { "select#": 1, "steps": [ { "creating_tmp_table": { "tmp_table_info": { "table": "intermediate_tmp_table", "row_length": 1799, "key_length": 0, "unique_constraint": false, "location": "memory (heap)", "row_limit_estimate": 9325 } } }, { "filesort_information": [ { "direction": "desc", "table": "intermediate_tmp_table", "field": "SendDate" }, { "direction": "asc", "table": "intermediate_tmp_table", "field": "GGUID" } ], "filesort_priority_queue_optimization": { "limit": 100, "rows_estimate": 35, "row_size": 30, "memory_available": 262144, "chosen": false, "cause": "quicksort_is_cheaper" }, "filesort_execution": [ ], "filesort_summary": { "rows": 25, "examined_rows": 25, "number_of_tmp_files": 0, "sort_buffer_size": 1330, "sort_mode": "" } } ] } } ] }00