Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-20444

More information regarding access of a table to be printed inside the optimizer_trace

    Details

      Description

      Example:

                              "table": "lineitem",
                              "best_access_path": {
                                "considered_access_paths": [
                                  {
                                    "access_type": "ref",
                                    "index": "PRIMARY",
                                    "rows": 1,
                                    "cost": 250.69,
                                    "chosen": true
                                  },
                                  {
                                    "access_type": "ref",
                                    "index": "i_l_orderkey",
                                    "rows": 1,
                                    "cost": 498.4,
                                    "chosen": false,
                                    "cause": "cost"
                                  },
                                  {
                                    "access_type": "ref",
                                    "index": "i_l_orderkey_quantity",
                                    "rows": 1,
                                    "cost": 498.4,
                                    "chosen": false,
                                    "cause": "cost"
                                  },
                                  {
                                    "type": "scan",
                                    "chosen": false,
                                    "cause": "cost"
                                  }
                                ]
      

      So here we see all the ref accesses and table_scan considered on table lineitem, just add the best access picked to the optimizer trace to make it clear

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                varun Varun Gupta
                Reporter:
                varun Varun Gupta
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: