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

PS re-execution: Use query plan of first execution as starting optimization point

Details

    Description

      Filing this based on discussion with monty:

      When we are re-executing a Prepared Statement, make the join optimizer use the join order from the previous execution as the starting point.

      This will allow to speed up join optimization: the optimizer will start with a [hopefully] good query plan with small cost. This will allow to prune away some join prefixes.

      Attachments

        Activity

          There are no comments yet on this issue.

          People

            Unassigned Unassigned
            psergei Sergei Petrunia
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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