Ensure Query Shape is “similar” to the current classic plan cache key in how it groups queries

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Done
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • Fully Compatible
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      The same set of queries we should generate a similar amount of plan cache entries.

      Add a workload that shuffles the order of fields in a query.

      Measure the time to sort fields during query shape calculation, for different query complexities.

      Generate queries based on existing $queryStats data and confirm that the number of plan cache entries is comparable before and after the plan cache key change.

            Assignee:
            Rui Liu
            Reporter:
            Ivan Fefer
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: