Test that both CBR and join queries can use persisted samples

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Fixed
    • Priority: Major - P3
    • 9.1.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • Fully Compatible
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      We have internalSamplingSizeOverride as well as internalJoinPlanSamplingSize. On the analyze path we only consult internalSamplingSizeOverride, but on the read path we may consult either depending on the query. This is confusing so we should write a test that documents this behavior. The test should ensure that both queries destined for CBR and queries destined for join optimization can use a persisted sample if one exists.

      This is in anticipation of removing the ability to specify sample size from the analyze command, as well as the anticipation of automated samples.

            Assignee:
            Carlos Alonso Pérez
            Reporter:
            Militsa Sotirova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: