The method cache (where cached question programs are stored) only shops the most up-to-date execution system. Plans also get evicted from the program cache resulting from memory force. Subsequently, question efficiency regressions caused by execution system adjustments is usually non-trivial and time consuming to take care of. There are two type