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

    XMLWordPrintable

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

              varun Varun Gupta (Inactive)
              varun Varun Gupta (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.