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

    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

        Activity

          People

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