Post reply

Duplicate statistics - execution plan disruption

  • May 14, 2020 at 5:50 pm

    #3751650

    Hello, I will need your insight on the content of the execution plans in relation to the statistics.

    Request 1: do the values ??in the <OptimizerStatsUsage> section only contain the statistics actually retained for the plan in question or is it the list of all potentially useful statistics?

    Request 2: for a particular step, how do you know which statistic is used?

    Request 3: if there are 2 statistics relating to the same column, on which criterion the statistic is chosen to make the estimates?

    thanks

  • May 15, 2020 at 6:10 pm

    #3752077

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply