{
    "steps": [
      {
        "join_preparation": {
          "select_id": 1,
          "steps": [
            {
              "expanded_query": "select sql_no_cache mll_app_magna_pure.mp_id AS mp_id,mll_app_magna_pure.mp_exam_id AS mp_exam_id,mll_app_magna_pure.mp_exam_no AS mp_exam_no,mll_app_magna_pure.mp_pat_no AS mp_pat_no,mll_app_magna_pure.mp_create_date AS mp_create_date,mll_app_magna_pure.mp_create_user AS mp_create_user,mll_app_magna_pure.mp_change_date AS mp_change_date,mll_app_magna_pure.mp_change_user AS mp_change_user,mll_app_magna_pure.mp_valid_from AS mp_valid_from,mll_app_magna_pure.mp_valid_to AS mp_valid_to,mll_app_magna_pure.mp_outputplate AS mp_outputplate,mll_app_magna_pure.mp_transferplate AS mp_transferplate from mll_app_magna_pure where mll_app_magna_pure.mp_valid_to = 99991231235555 and (mll_app_magna_pure.mp_transferplate = '0502212000095962' or mll_app_magna_pure.mp_outputplate = '0502212000095962')"
            }
          ]
        }
      },
      {
        "join_optimization": {
          "select_id": 1,
          "steps": [
            {
              "condition_processing": {
                "condition": "WHERE",
                "original_condition": "mll_app_magna_pure.mp_valid_to = 99991231235555 and (mll_app_magna_pure.mp_transferplate = '0502212000095962' or mll_app_magna_pure.mp_outputplate = '0502212000095962')",
                "steps": [
                  {
                    "transformation": "equality_propagation",
                    "resulting_condition": "(multiple equal('0502212000095962', mll_app_magna_pure.mp_transferplate) or multiple equal('0502212000095962', mll_app_magna_pure.mp_outputplate)) and multiple equal(99991231235555, mll_app_magna_pure.mp_valid_to)"
                  },
                  {
                    "transformation": "constant_propagation",
                    "resulting_condition": "(multiple equal('0502212000095962', mll_app_magna_pure.mp_transferplate) or multiple equal('0502212000095962', mll_app_magna_pure.mp_outputplate)) and multiple equal(99991231235555, mll_app_magna_pure.mp_valid_to)"
                  },
                  {
                    "transformation": "trivial_condition_removal",
                    "resulting_condition": "(multiple equal('0502212000095962', mll_app_magna_pure.mp_transferplate) or multiple equal('0502212000095962', mll_app_magna_pure.mp_outputplate)) and multiple equal(99991231235555, mll_app_magna_pure.mp_valid_to)"
                  }
                ]
              }
            },
            {
              "table_dependencies": [
                {
                  "table": "mll_app_magna_pure",
                  "row_may_be_null": false,
                  "map_bit": 0,
                  "depends_on_map_bits": []
                }
              ]
            },
            {
              "ref_optimizer_key_uses": [
                {
                  "table": "mll_app_magna_pure",
                  "field": "mp_valid_to",
                  "equals": "99991231235555",
                  "null_rejecting": false
                }
              ]
            },
            {
              "rows_estimation": [
                {
                  "table": "mll_app_magna_pure",
                  "range_analysis": {
                    "table_scan": {
                      "rows": 1272805,
                      "cost": 300067
                    },
                    "potential_range_indexes": [
                      {
                        "index": "mp_transferplate_idx",
                        "usable": true,
                        "key_parts": [
                          "mp_valid_to",
                          "mp_transferplate",
                          "mp_outputplate"
                        ]
                      }
                    ],
                    "setup_range_conditions": [],
                    "analyzing_range_alternatives": {
                      "range_scan_alternatives": [
                        {
                          "index": "mp_transferplate_idx",
                          "ranges": [
                            "(99991231235555) <= (mp_valid_to) <= (99991231235555)"
                          ],
                          "rowid_ordered": false,
                          "using_mrr": false,
                          "index_only": false,
                          "rows": 636402,
                          "cost": 767840.3123,
                          "chosen": false,
                          "cause": "cost"
                        }
                      ],
                      "analyzing_roworder_intersect": {
                        "cause": "too few roworder scans"
                      },
                      "analyzing_index_merge_union": [
                        {
                          "indexes_to_merge": [
                            {
                              "range_scan_alternatives": [
                                {
                                  "index": "mp_sample_no_idx",
                                  "ranges": [
                                    "(99991231235555) <= (mp_valid_to) <= (99991231235555)"
                                  ],
                                  "rowid_ordered": false,
                                  "using_mrr": false,
                                  "index_only": true,
                                  "rows": 636402,
                                  "cost": 128705.9795,
                                  "chosen": true
                                },
                                {
                                  "index": "mp_transferplate_idx",
                                  "ranges": [
                                    "(99991231235555,0502212000095962) <= (mp_valid_to,mp_transferplate) <= (99991231235555,0502212000095962)"
                                  ],
                                  "rowid_ordered": false,
                                  "using_mrr": false,
                                  "index_only": true,
                                  "rows": 1,
                                  "cost": 0.34585444,
                                  "chosen": true
                                }
                              ],
                              "index_to_merge": "mp_transferplate_idx",
                              "cumulated_cost": 0.34585444
                            },
                            {
                              "range_scan_alternatives": [
                                {
                                  "index": "mp_sample_no_idx",
                                  "ranges": [
                                    "(99991231235555) <= (mp_valid_to) <= (99991231235555)"
                                  ],
                                  "rowid_ordered": false,
                                  "using_mrr": false,
                                  "index_only": true,
                                  "rows": 636402,
                                  "cost": 128705.9795,
                                  "chosen": true
                                },
                                {
                                  "index": "mp_transferplate_idx",
                                  "ranges": [
                                    "(99991231235555) <= (mp_valid_to) <= (99991231235555)"
                                  ],
                                  "rowid_ordered": false,
                                  "using_mrr": false,
                                  "index_only": true,
                                  "rows": 636402,
                                  "cost": 131438.3123,
                                  "chosen": false,
                                  "cause": "cost"
                                },
                                {
                                  "index": "mp_mpr_no_idx",
                                  "ranges": [
                                    "(99991231235555) <= (mp_valid_to) <= (99991231235555)"
                                  ],
                                  "rowid_ordered": false,
                                  "using_mrr": false,
                                  "index_only": true,
                                  "rows": 636402,
                                  "cost": 128410.139,
                                  "chosen": true
                                }
                              ],
                              "index_to_merge": "mp_mpr_no_idx",
                              "cumulated_cost": 128410.4848
                            }
                          ],
                          "cost_of_reading_ranges": 128410.4848,
                          "cost_sort_rowid_and_read_disk": 158992.1026,
                          "cost_duplicate_removal": 29781.61806,
                          "total_cost": 317184.2055
                        }
                      ]
                    },
                    "group_index_range": {
                      "chosen": false,
                      "cause": "no group by or distinct"
                    }
                  }
                },
                {
                  "selectivity_for_indexes": [
                    {
                      "index_name": "mp_sample_no_idx",
                      "selectivity_from_index": 0.499999607
                    }
                  ],
                  "selectivity_for_columns": [],
                  "cond_selectivity": 0.499999607
                }
              ]
            },
            {
              "considered_execution_plans": [
                {
                  "plan_prefix": [],
                  "table": "mll_app_magna_pure",
                  "best_access_path": {
                    "considered_access_paths": [
                      {
                        "access_type": "ref",
                        "index": "mp_sample_no_idx",
                        "used_range_estimates": true,
                        "rows": 636402,
                        "cost": 637827.5595,
                        "chosen": true
                      },
                      {
                        "access_type": "ref",
                        "index": "mp_valid_to",
                        "used_range_estimates": true,
                        "rows": 636402,
                        "cost": 639375.5302,
                        "chosen": false,
                        "cause": "cost"
                      },
                      {
                        "access_type": "ref",
                        "index": "mp_transferplate_idx",
                        "used_range_estimates": true,
                        "rows": 636402,
                        "cost": 640559.8923,
                        "chosen": false,
                        "cause": "cost"
                      },
                      {
                        "access_type": "scan",
                        "resulting_rows": 636402,
                        "cost": 172784.6,
                        "chosen": true
                      }
                    ],
                    "chosen_access_method": {
                      "type": "scan",
                      "records": 636402,
                      "cost": 172784.6,
                      "uses_join_buffering": false
                    }
                  },
                  "rows_for_plan": 636402,
                  "cost_for_plan": 300065,
                  "estimated_join_cardinality": 636402
                }
              ]
            },
            {
              "best_join_order": ["mll_app_magna_pure"]
            },
            {
              "attaching_conditions_to_tables": {
                "original_condition": "mll_app_magna_pure.mp_valid_to = 99991231235555 and (mll_app_magna_pure.mp_transferplate = '0502212000095962' or mll_app_magna_pure.mp_outputplate = '0502212000095962')",
                "attached_conditions_computation": [],
                "attached_conditions_summary": [
                  {
                    "table": "mll_app_magna_pure",
                    "attached": "mll_app_magna_pure.mp_valid_to = 99991231235555 and (mll_app_magna_pure.mp_transferplate = '0502212000095962' or mll_app_magna_pure.mp_outputplate = '0502212000095962')"
                  }
                ]
              }
            }
          ]
        }
      },
      {
        "join_execution": {
          "select_id": 1,
          "steps": []
        }
      }
    ]
  }