SELECT 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 `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 `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": 106421, "cost": 5291 } }, { "table": "`emailstoreorel`", "range_analysis": { "table_scan": { "rows": 119063, "cost": 24618 }, "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": 24394, "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": 47430, "cost": 57102, "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": 59706, "cost": 71833, "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": 22878, "cost": 27640, "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": 59531, "cost": 12198, "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": 59531, "ranges": [ "64 <= EIMRight" ] }, "rows_for_plan": 59531, "cost_for_plan": 12198, "chosen": true } } }, { "table": "`tablerelation` `rel`", "table_scan": { "rows": 2723746, "cost": 28672 } }, { "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "table_scan": { "rows": 91848, "cost": 3689 } }, { "table": "`todoorel`", "range_analysis": { "table_scan": { "rows": 200878, "cost": 41622 }, "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": 41156, "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": 50220, "cost": 60450, "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": 53196, "cost": 64021, "chosen": false, "cause": "cost" }, { "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": 44454, "cost": 53531, "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": 100439, "cost": 20579, "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": 100439, "ranges": [ "64 <= EIMRight" ] }, "rows_for_plan": 100439, "cost_for_plan": 20579, "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": 91848, "cost": 22059, "chosen": true } ] }, "cost_for_plan": 22059, "rows_for_plan": 91848, "rest_of_plan": [ { "plan_prefix": [ "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "rows": 1, "cost": 91848, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "rows": 1, "cost": 91848, "chosen": false }, { "access_type": "range", "rows": 44454, "cost": 3.74e9, "chosen": false } ] }, "cost_for_plan": 132276, "rows_for_plan": 91848, "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": 91848, "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": 91848, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 242494, "rows_for_plan": 91848, "sort_cost": 91848, "new_cost_for_plan": 334342, "chosen": 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": 91848, "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": 91848, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 132276, "rows_for_plan": 91848, "rest_of_plan": [ { "plan_prefix": [ "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`tablerelation` `rel`" ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "rows": 1, "cost": 91848, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "rows": 1, "cost": 91848, "chosen": false }, { "access_type": "range", "rows": 44454, "cost": 3.74e9, "chosen": false } ] }, "cost_for_plan": 242494, "rows_for_plan": 91848, "sort_cost": 91848, "new_cost_for_plan": 334342, "chosen": false } ] } ] }, { "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": 44454, "cost": 40667, "chosen": true } ] }, "cost_for_plan": 40667, "rows_for_plan": 44454, "rest_of_plan": [ { "plan_prefix": [ "`todoorel`" ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 44454, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 44454, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 68886, "cost": 6.12e8, "chosen": false } ] }, "cost_for_plan": 94011, "rows_for_plan": 44454, "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": 44454, "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": 44454, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 147356, "rows_for_plan": 44454, "sort_cost": 44454, "new_cost_for_plan": 191810, "chosen": true } ] }, { "plan_prefix": [ "`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": 44454, "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": 44454, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 94011, "rows_for_plan": 44454, "rest_of_plan": [ { "plan_prefix": [ "`todoorel`", "`tablerelation` `rel`" ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 44454, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 44454, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 68886, "cost": 6.12e8, "chosen": false } ] }, "cost_for_plan": 147356, "rows_for_plan": 44454, "sort_cost": 44454, "new_cost_for_plan": 191810, "chosen": false } ] } ] }, { "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.72e6, "cost": 573421, "chosen": true } ] }, "cost_for_plan": 573421, "rows_for_plan": 2.72e6, "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": 22878, "cost": 24104, "chosen": true } ] }, "cost_for_plan": 24104, "rows_for_plan": 22878, "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": 91848, "cost": 4.2e8, "chosen": true } ] }, "cost_for_plan": 4.2e8, "rows_for_plan": 2.1e9, "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": 2.1e9, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "rows": 1, "cost": 2.1e9, "chosen": false }, { "access_type": "range", "rows": 44454, "cost": 8.5e13, "chosen": false } ] }, "cost_for_plan": 2.94e9, "rows_for_plan": 2.1e9, "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": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 79816, "cost": 3.4e13, "chosen": false } ] }, "cost_for_plan": 3.36e9, "rows_for_plan": 2.1e9, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`todoorel`", "`emailstore0` `emailstore`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 1, "cost": 2.1e9, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 2.1e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 2.19e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 2.1e9, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 5.88e9, "rows_for_plan": 2.1e9, "semijoin_strategy_choice": [ { "strategy": "DuplicatesWeedout", "cost": 6.3e9, "rows": 1, "duplicate_tables_left": true, "chosen": true } ], "sort_cost": 1, "new_cost_for_plan": 6.3e9, "chosen": true } ] }, { "plan_prefix": [ "`emailstoreorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`todoorel`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 1, "cost": 2.1e9, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 2.1e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 2.19e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 2.1e9, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 5.46e9, "rows_for_plan": 2.1e9, "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": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 79816, "cost": 3.4e13, "chosen": false } ] }, "cost_for_plan": 5.88e9, "rows_for_plan": 2.1e9, "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": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 79816, "cost": 1.6e13, "chosen": false } ] } } ] }, "cost": 4.07e8, "rows": 22878, "duplicate_tables_left": true, "chosen": true }, { "strategy": "DuplicatesWeedout", "cost": 6.3e9, "rows": 1, "duplicate_tables_left": true, "chosen": true } ], "sort_cost": 1, "new_cost_for_plan": 6.3e9, "chosen": false } ] } ] }, { "plan_prefix": [ "`emailstoreorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 79816, "cost": 3.4e13, "chosen": false } ] }, "cost_for_plan": 8.41e8, "rows_for_plan": 2.1e9, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`emailstore0` `emailstore`" ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "rows": 1, "cost": 2.1e9, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "rows": 1, "cost": 2.1e9, "chosen": false }, { "access_type": "range", "rows": 44454, "cost": 8.5e13, "chosen": false } ] }, "cost_for_plan": 3.36e9, "rows_for_plan": 2.1e9, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`emailstore0` `emailstore`", "`todoorel`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 1, "cost": 2.1e9, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 2.1e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 2.19e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 2.1e9, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 5.88e9, "rows_for_plan": 2.1e9, "semijoin_strategy_choice": [ { "strategy": "DuplicatesWeedout", "cost": 6.3e9, "rows": 1, "duplicate_tables_left": true, "chosen": true } ], "sort_cost": 1, "new_cost_for_plan": 6.3e9, "chosen": false } ] }, { "plan_prefix": [ "`emailstoreorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`emailstore0` `emailstore`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 1, "cost": 2.1e9, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 2.1e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 2.19e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 2.1e9, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 3.36e9, "rows_for_plan": 2.1e9, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`emailstore0` `emailstore`", "`tablerelation` `rel`" ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "rows": 1, "cost": 2.1e9, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "rows": 1, "cost": 2.1e9, "chosen": false }, { "access_type": "range", "rows": 44454, "cost": 8.5e13, "chosen": false } ] }, "cost_for_plan": 5.88e9, "rows_for_plan": 2.1e9, "semijoin_strategy_choice": [ { "strategy": "DuplicatesWeedout", "cost": 6.3e9, "rows": 1, "duplicate_tables_left": true, "chosen": true } ], "sort_cost": 1, "new_cost_for_plan": 6.3e9, "chosen": false } ] } ] }, { "plan_prefix": [ "`emailstoreorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 1, "cost": 2.1e9, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 2.1e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 2.19e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 2.1e9, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 2.94e9, "rows_for_plan": 2.1e9, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`tablerelation` `rel`" ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "rows": 1, "cost": 2.1e9, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "rows": 1, "cost": 2.1e9, "chosen": false }, { "access_type": "range", "rows": 44454, "cost": 8.5e13, "chosen": false } ] }, "cost_for_plan": 5.46e9, "rows_for_plan": 2.1e9, "semijoin_strategy_choice": [ { "strategy": "MaterializeScan", "choice": "deferred" } ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`tablerelation` `rel`", "`todoorel`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 79816, "cost": 3.4e13, "chosen": false } ] }, "cost_for_plan": 5.88e9, "rows_for_plan": 2.1e9, "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": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 79816, "cost": 1.6e13, "chosen": false } ] } } ] }, "cost": 4.07e8, "rows": 22878, "duplicate_tables_left": true, "chosen": true }, { "strategy": "DuplicatesWeedout", "cost": 6.3e9, "rows": 1, "duplicate_tables_left": true, "chosen": true } ], "sort_cost": 1, "new_cost_for_plan": 6.3e9, "chosen": false } ] }, { "plan_prefix": [ "`emailstoreorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`tablerelation` `rel`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 79816, "cost": 3.4e13, "chosen": false } ] }, "cost_for_plan": 3.36e9, "rows_for_plan": 2.1e9, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`tablerelation` `rel`", "`emailstore0` `emailstore`" ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "rows": 1, "cost": 2.1e9, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "rows": 1, "cost": 2.1e9, "chosen": false }, { "access_type": "range", "rows": 44454, "cost": 8.5e13, "chosen": false } ] }, "cost_for_plan": 5.88e9, "rows_for_plan": 2.1e9, "semijoin_strategy_choice": [ { "strategy": "DuplicatesWeedout", "cost": 6.3e9, "rows": 1, "duplicate_tables_left": true, "chosen": true } ], "sort_cost": 1, "new_cost_for_plan": 6.3e9, "chosen": false } ] } ] } ] }, { "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": 44454, "cost": 9.3e8, "chosen": true } ] }, "cost_for_plan": 9.3e8, "rows_for_plan": 1.02e9, "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": 44454, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 44454, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 68886, "cost": 1.4e13, "chosen": false } ] }, "cost_for_plan": 1.13e9, "rows_for_plan": 1.02e9, "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": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 79816, "cost": 1.6e13, "chosen": false } ] }, "cost_for_plan": 1.34e9, "rows_for_plan": 1.02e9, "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": 1, "cost": 1.02e9, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 1.02e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 1.06e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 1.02e9, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 2.56e9, "rows_for_plan": 1.02e9, "semijoin_strategy_choice": [ { "strategy": "DuplicatesWeedout", "cost": 2.76e9, "rows": 1, "duplicate_tables_left": true, "chosen": true } ], "sort_cost": 1, "new_cost_for_plan": 2.76e9, "chosen": true } ] }, { "plan_prefix": [ "`emailstoreorel`", "`todoorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 1, "cost": 1.02e9, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 1.02e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 1.06e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 1.02e9, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 2.35e9, "rows_for_plan": 1.02e9, "semijoin_strategy_choice": [ { "strategy": "MaterializeScan", "choice": "deferred" } ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todoorel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`tablerelation` `rel`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 79816, "cost": 1.6e13, "chosen": false } ] }, "cost_for_plan": 2.56e9, "rows_for_plan": 1.02e9, "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": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 79816, "cost": 1.6e13, "chosen": false } ] } } ] }, "cost": 4.07e8, "rows": 22878, "duplicate_tables_left": true, "chosen": true }, { "strategy": "DuplicatesWeedout", "cost": 2.76e9, "rows": 1, "duplicate_tables_left": true, "chosen": true } ], "sort_cost": 1, "new_cost_for_plan": 2.76e9, "chosen": false } ] } ] }, { "plan_prefix": [ "`emailstoreorel`", "`todoorel`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 79816, "cost": 1.6e13, "chosen": false } ] }, "cost_for_plan": 1.13e9, "rows_for_plan": 1.02e9, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todoorel`", "`emailstore0` `emailstore`" ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 44454, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 44454, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 68886, "cost": 1.4e13, "chosen": false } ] }, "cost_for_plan": 1.34e9, "rows_for_plan": 1.02e9, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todoorel`", "`emailstore0` `emailstore`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 1, "cost": 1.02e9, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 1.02e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 1.06e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 1.02e9, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 2.56e9, "rows_for_plan": 1.02e9, "semijoin_strategy_choice": [ { "strategy": "DuplicatesWeedout", "cost": 2.76e9, "rows": 1, "duplicate_tables_left": true, "chosen": true } ], "sort_cost": 1, "new_cost_for_plan": 2.76e9, "chosen": false } ] }, { "plan_prefix": [ "`emailstoreorel`", "`todoorel`", "`emailstore0` `emailstore`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 1, "cost": 1.02e9, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 1.02e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 1.06e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 1.02e9, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 2.35e9, "rows_for_plan": 1.02e9, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todoorel`", "`emailstore0` `emailstore`", "`tablerelation` `rel`" ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 68886, "cost": 1.4e13, "chosen": false } ] }, "cost_for_plan": 2.56e9, "rows_for_plan": 1.02e9, "semijoin_strategy_choice": [ { "strategy": "DuplicatesWeedout", "cost": 2.76e9, "rows": 1, "duplicate_tables_left": true, "chosen": true } ], "sort_cost": 1, "new_cost_for_plan": 2.76e9, "chosen": true } ] } ] }, { "plan_prefix": [ "`emailstoreorel`", "`todoorel`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 1, "cost": 1.02e9, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 1.02e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 1.06e9, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 1.02e9, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 2.15e9, "rows_for_plan": 1.02e9, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todoorel`", "`tablerelation` `rel`" ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 68886, "cost": 1.4e13, "chosen": false } ] }, "cost_for_plan": 2.35e9, "rows_for_plan": 1.02e9, "semijoin_strategy_choice": [ { "strategy": "MaterializeScan", "choice": "deferred" } ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todoorel`", "`tablerelation` `rel`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 79816, "cost": 1.6e13, "chosen": false } ] }, "cost_for_plan": 2.56e9, "rows_for_plan": 1.02e9, "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": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 79816, "cost": 1.6e13, "chosen": false } ] } } ] }, "cost": 4.07e8, "rows": 22878, "duplicate_tables_left": true, "chosen": true }, { "strategy": "DuplicatesWeedout", "cost": 2.76e9, "rows": 1, "duplicate_tables_left": true, "chosen": true } ], "sort_cost": 1, "new_cost_for_plan": 2.76e9, "chosen": false } ] }, { "plan_prefix": [ "`emailstoreorel`", "`todoorel`", "`tablerelation` `rel`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 79816, "cost": 1.6e13, "chosen": false } ] }, "cost_for_plan": 2.35e9, "rows_for_plan": 1.02e9, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`todoorel`", "`tablerelation` `rel`", "`emailstore0` `emailstore`" ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 68886, "cost": 1.4e13, "chosen": false } ] }, "cost_for_plan": 2.56e9, "rows_for_plan": 1.02e9, "semijoin_strategy_choice": [ { "strategy": "DuplicatesWeedout", "cost": 2.76e9, "rows": 1, "duplicate_tables_left": true, "chosen": true } ], "sort_cost": 1, "new_cost_for_plan": 2.76e9, "chosen": false } ] } ] } ] }, { "plan_prefix": [ "`emailstoreorel`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 79816, "cost": 3.65e8, "chosen": false } ] }, "cost_for_plan": 51557, "rows_for_plan": 22878, "semijoin_strategy_choice": [ { "strategy": "DuplicatesWeedout", "cost": 56135, "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": 91848, "cost": 22061, "chosen": true } ] }, "cost_for_plan": 78196, "rows_for_plan": 91848, "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": 91848, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "rows": 1, "cost": 91848, "chosen": false }, { "access_type": "range", "rows": 44454, "cost": 3.74e9, "chosen": false } ] }, "cost_for_plan": 188414, "rows_for_plan": 91848, "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": 1, "cost": 91848, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 91848, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 95675, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 91848, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 298631, "rows_for_plan": 91848, "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": 91848, "cost": 22059, "chosen": true } ] } } ] }, "cost": 298629, "rows": 1, "chosen": true }, { "strategy": "MaterializeLookup", "cost": 212384, "rows": 1, "duplicate_tables_left": false, "chosen": true }, { "strategy": "DuplicatesWeedout", "cost": 1.68e9, "rows": 1, "duplicate_tables_left": false, "chosen": false } ], "sort_cost": 1, "new_cost_for_plan": 212385, "chosen": true } ] }, { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 1, "cost": 91848, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 91848, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 95675, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 91848, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 188414, "rows_for_plan": 91848, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`", "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "`tablerelation` `rel`" ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "rows": 1, "cost": 91848, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "rows": 1, "cost": 91848, "chosen": false }, { "access_type": "range", "rows": 44454, "cost": 3.74e9, "chosen": false } ] }, "cost_for_plan": 298631, "rows_for_plan": 91848, "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": 91848, "cost": 22059, "chosen": true } ] } } ] }, "cost": 298629, "rows": 1, "chosen": true }, { "strategy": "MaterializeLookup", "cost": 212384, "rows": 1, "duplicate_tables_left": false, "chosen": true }, { "strategy": "DuplicatesWeedout", "cost": 1.68e9, "rows": 1, "duplicate_tables_left": false, "chosen": false } ], "sort_cost": 1, "new_cost_for_plan": 212385, "chosen": 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": 44454, "cost": 40667, "chosen": true } ] }, "cost_for_plan": 96802, "rows_for_plan": 44454, "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": 44454, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 44454, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 68886, "cost": 6.13e8, "chosen": false } ] }, "cost_for_plan": 150147, "rows_for_plan": 44454, "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": 1, "cost": 44454, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 44454, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 46307, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 44454, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 203491, "rows_for_plan": 44454, "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": 44454, "cost": 40667, "chosen": true } ] } } ] }, "cost": 203491, "rows": 1, "chosen": true }, { "strategy": "MaterializeLookup", "cost": 212384, "rows": 1, "duplicate_tables_left": false, "chosen": false }, { "strategy": "DuplicatesWeedout", "cost": 8.14e8, "rows": 1, "duplicate_tables_left": false, "chosen": false } ], "sort_cost": 1, "new_cost_for_plan": 203492, "chosen": true } ] }, { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`", "`todoorel`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 1, "cost": 44454, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "rows": 1, "cost": 44454, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 46307, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "rows": 1, "cost": 44454, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 150147, "rows_for_plan": 44454, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`", "`todoorel`", "`tablerelation` `rel`" ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 68886, "cost": 6.13e8, "chosen": false } ] }, "cost_for_plan": 181915, "rows_for_plan": 44454, "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": 44454, "cost": 40667, "chosen": true } ] } } ] }, "cost": 181915, "rows": 1, "chosen": true }, { "strategy": "MaterializeLookup", "cost": 212384, "rows": 1, "duplicate_tables_left": false, "chosen": false }, { "strategy": "DuplicatesWeedout", "cost": 8.14e8, "rows": 1, "duplicate_tables_left": false, "chosen": false } ], "sort_cost": 1, "new_cost_for_plan": 181916, "chosen": true } ] } ] }, { "plan_prefix": [ "`emailstoreorel`", "`emailstore0` `emailstore`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 1, "cost": 1.2, "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": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "usable": false, "chosen": false }, { "access_type": "scan", "cost": 573421, "rows": 2723746, "cause": "cost", "chosen": false } ] }, "cost_for_plan": 56136, "rows_for_plan": 1, "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": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 68886, "cost": 22061, "chosen": true } ] }, "cost_for_plan": 78197, "rows_for_plan": 68886, "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": 68886, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "rows": 1, "cost": 68886, "chosen": false }, { "access_type": "range", "rows": 44454, "cost": 2.8e9, "chosen": false } ] }, "cost_for_plan": 160860, "rows_for_plan": 68886, "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": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "rows": 68886, "cost": 22059, "chosen": true } ] } } ] }, "cost": 160858, "rows": 1, "chosen": true }, { "strategy": "MaterializeLookup", "cost": 212384, "rows": 1, "duplicate_tables_left": false, "chosen": false }, { "strategy": "DuplicatesWeedout", "cost": 9.46e8, "rows": 1, "duplicate_tables_left": false, "chosen": false } ], "sort_cost": 1, "new_cost_for_plan": 160859, "chosen": 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": 1.2, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "rows": 1, "cost": 1.2, "chosen": false }, { "access_type": "range", "cost": 40666, "rows": 100439, "cause": "cost", "chosen": false } ] }, "cost_for_plan": 56138, "rows_for_plan": 1, "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": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 68886, "cost": 22061, "chosen": true } ] }, "cost_for_plan": 78198, "rows_for_plan": 68886, "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": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "rows": 68886, "cost": 22059, "chosen": true } ] } } ] }, "cost": 78196, "rows": 1, "chosen": true }, { "strategy": "MaterializeLookup", "cost": 212384, "rows": 1, "duplicate_tables_left": false, "chosen": false }, { "strategy": "DuplicatesWeedout", "cost": 6.3e8, "rows": 1, "duplicate_tables_left": false, "chosen": false } ], "sort_cost": 1, "new_cost_for_plan": 78197, "chosen": true } ] } ] } ] }, { "plan_prefix": [ "`emailstoreorel`" ], "table": "`tablerelation` `rel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_GUID1296", "rows": 1, "cost": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 23832, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_2", "usable": false, "chosen": false }, { "access_type": "scan", "cost": 573421, "rows": 2723746, "cause": "cost", "chosen": false } ] }, "cost_for_plan": 51557, "rows_for_plan": 22878, "semijoin_strategy_choice": [ ], "rest_of_plan": [ { "plan_prefix": [ "`emailstoreorel`", "`tablerelation` `rel`" ], "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 68886, "cost": 3.15e8, "chosen": false } ] }, "cost_for_plan": 79011, "rows_for_plan": 22878, "semijoin_strategy_choice": [ ], "pruned_by_cost": true }, { "plan_prefix": [ "`emailstoreorel`", "`tablerelation` `rel`" ], "table": "`todoorel`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "IDX_TableGUID255", "rows": 1, "cost": 22878, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "range", "rows": 44454, "cost": 9.3e8, "chosen": false } ] }, "cost_for_plan": 79011, "rows_for_plan": 22878, "semijoin_strategy_choice": [ ], "pruned_by_cost": true }, { "plan_prefix": [ "`emailstoreorel`", "`tablerelation` `rel`" ], "table": "`emailstore0` `emailstore`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 1, "cost": 22878, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 22878, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 79816, "cost": 3.65e8, "chosen": false } ] }, "cost_for_plan": 79011, "rows_for_plan": 22878, "semijoin_strategy_choice": [ ], "pruned_by_cost": 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": 91848, "cost": 22059, "chosen": true } ] }, "cost_for_plan": 22059, "rows_for_plan": 91848, "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": 22878, "cost": 2.21e9, "chosen": true } ] }, "cost_for_plan": 2.21e9, "rows_for_plan": 2.1e9, "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": 91848, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V510", "rows": 1, "cost": 91848, "chosen": false }, { "access_type": "range", "rows": 44454, "cost": 3.74e9, "chosen": false } ] }, "cost_for_plan": 132276, "rows_for_plan": 91848, "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": 106421, "cost": 1.95e9, "chosen": true } ] }, "cost_for_plan": 1.96e9, "rows_for_plan": 9.77e9, "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": 91848, "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": 91848, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 132276, "rows_for_plan": 91848, "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": 44454, "cost": 40667, "chosen": true } ] }, "cost_for_plan": 40667, "rows_for_plan": 44454, "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": 22878, "cost": 1.07e9, "chosen": true } ] }, "cost_for_plan": 1.07e9, "rows_for_plan": 1.02e9, "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": 44454, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 44454, "chosen": false }, { "access_type": "scan", "using_join_cache": true, "rows": 68886, "cost": 6.12e8, "chosen": false } ] }, "cost_for_plan": 94011, "rows_for_plan": 44454, "semijoin_strategy_choice": [ ], "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": 106421, "cost": 9.46e8, "chosen": true } ] }, "cost_for_plan": 9.46e8, "rows_for_plan": 4.73e9, "semijoin_strategy_choice": [ ], "pruned_by_cost": true }, { "plan_prefix": [ "`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": 44454, "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": 44454, "chosen": false }, { "access_type": "scan", "cause": "covering_index_better_than_full_scan", "chosen": false } ] }, "cost_for_plan": 94011, "rows_for_plan": 44454, "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": 106421, "cost": 26575, "chosen": true } ] }, "cost_for_plan": 26575, "rows_for_plan": 106421, "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": 106421, "chosen": true }, { "access_type": "ref", "index": "IX_MIXOREL_V517", "rows": 1, "cost": 106421, "chosen": false }, { "access_type": "range", "rows": 22878, "cost": 2.57e9, "chosen": false } ] }, "cost_for_plan": 154280, "rows_for_plan": 106421, "semijoin_strategy_choice": [ { "strategy": "FirstMatch", "recalculate_access_paths_and_cost": { "tables": [ ] }, "cost": 154280, "rows": 106421, "chosen": true }, { "strategy": "DuplicatesWeedout", "cost": 196851, "rows": 106421, "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": 91848, "cost": 1.96e9, "chosen": true } ] }, "cost_for_plan": 1.96e9, "rows_for_plan": 9.77e9, "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": 44454, "cost": 4.33e9, "chosen": true } ] }, "cost_for_plan": 4.33e9, "rows_for_plan": 4.73e9, "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": 1, "cost": 106421, "chosen": true }, { "access_type": "ref", "index": "IDX_GUID2297", "usable": false, "chosen": false }, { "access_type": "ref", "index": "IX_MIDX_V5_1", "rows": 2, "cost": 110856, "chosen": false }, { "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": 154280, "rows_for_plan": 106421, "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.72e6, "cost": 573421, "chosen": true } ] }, "cost_for_plan": 573421, "rows_for_plan": 2.72e6, "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": 2.72e6, "chosen": true }, { "access_type": "ref", "index": "IDX_GGUID_UNIQUE", "rows": 1, "cost": 2.72e6, "chosen": false }, { "access_type": "scan", "rows": 68886, "cost": 22059, "chosen": true } ] } } ] } }, { "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": 22878 } }, { "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "rechecking_index_usage": { "recheck_reason": "not_first_table", "range_analysis": { "table_scan": { "rows": 91848, "cost": 110220 }, "potential_range_indices": [ { "index": "PRIMARY", "usable": true, "key_parts": [ "GGUID" ] }, { "index": "IDX_GGUID_UNIQUE", "usable": true, "key_parts": [ "GGUID" ] }, { "index": "IDX_End250", "usable": false, "cause": "not_applicable" }, { "index": "IDX_InsertTimestamp245", "usable": false, "cause": "not_applicable" }, { "index": "IDX_Keyword246", "usable": false, "cause": "not_applicable" }, { "index": "IDX_Periodid251", "usable": false, "cause": "not_applicable" }, { "index": "IDX_Start248", "usable": false, "cause": "not_applicable" }, { "index": "IDX_UpdateTimestamp252", "usable": false, "cause": "not_applicable" }, { "index": "IDX_TODO_PersonInCharge", "usable": false, "cause": "not_applicable" }, { "index": "IDX_EXCLUSION_EVENT", "usable": false, "cause": "not_applicable" }, { "index": "IDX_ACCOUNTINFORMATION_AutoGenerated", "usable": false, "cause": "not_applicable" }, { "index": "IDX_TODO_ALARM", "usable": false, "cause": "not_applicable" } ], "setup_range_conditions": [ ], "group_index_range": { "chosen": false, "cause": "not_single_table" }, "analyzing_range_alternatives": { "range_scan_alternatives": [ { "index": "PRIMARY", "chosen": false, "cause": "unknown" }, { "index": "IDX_GGUID_UNIQUE", "chosen": false, "cause": "unknown" } ], "analyzing_roworder_intersect": { "usable": false, "cause": "too_few_roworder_scans" } } } } } ], "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`.`GGUID` = `rel`.`GUID2`) and (`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": 14913080 } } }, { "table": "`emailstoreorel`", "access_type": "range" }, { "table": "`emailstore0` `emailstore`" }, { "table": "`tablerelation` `rel`" }, { "table": "`todoorel`" }, { "table": "`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`", "access_type": "table_scan" } ] } ] } }, { "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": 149213 } } }, { "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": 34, "row_size": 30, "memory_available": 262144, "chosen": false, "cause": "quicksort_is_cheaper" }, "filesort_execution": [ ], "filesort_summary": { "rows": 24, "examined_rows": 24, "number_of_tmp_files": 0, "sort_buffer_size": 1292, "sort_mode": "" } } ] } } ] }00