Why the execution plan changed? Case study

OverviewAt some point in time the execution plan of the SQL_ID etp65bryqtd2d changed. The new execution plan drops on performance from an Avg. of 0.01 seconds per execution to an Avg. of 1.5 seconds per execution.This increase on elapsed time per execution provoke that the application can’t process work orders fast enough, the work queue… Continue reading Why the execution plan changed? Case study