M201 Lesson 3.8 Query plan cache evicted on threshold

On that lesson,

It is said that the query plan cache will be discarded / evicted if

amount of work by performed by the first portion of the query exceeds amoun of work performed by the winning plan (factor of 10)

Can I have a more explanation of what it means? An example perhaps?

Hi @Altiano_Gerung,

You can refer to the following documentation link:

Please feel free to reach out if you have any questions.

Kind Regards,
Sonali