At a high level, SQL queries use statistics and other variables to determine what execution plan to run. As a result, a given SQL statement (SQL ID) may end up having multiple execution plans (hash plans) over time. Depending on the execution plan selected at runtime, performance can improve or degrade accordingly.