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

Save old query execution plans and choose appropiate plan for execution

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      Customer wants to have the ability to save query execution plans and then be able to choose which to use for execution.

      I recommended log-slow-verbosity with query plan & index hints but customer is not happy with that.

      They are expecting a feature similar to Oracles.
      https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_3183.htm#REFRN23447
      https://docs.oracle.com/database/121/TGSQL/tgsql_profiles.htm#TGSQL604

      Please see if this is feasible and let me know if you require any information.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              susmeet.khaire Susmeet Khaire
              Votes:
              2 Vote for this issue
              Watchers:
              6 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.