Applicate Baseline
Have you ever been in a situation in which some database queries that used to behave well suddenly started performing poorly? More likely than not, you traced the cause back to a change in the execution plan. Further analysis may have revealed that the performance change was due to newly collected optimizer statistics on the tables and indexes referred to in those queries. One of the many method to secure the execution plan is to use a baseline Below we will explain how to set an execution plan with a baseline having already ‘the optimal plan in memory or having...