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?