either i've misunderstood, or you're missing the point. if you cache the statement then you get a miss if the different literals change. remember that (again,

either i've misunderstood, or you're missing the point. if you cache the statement then you get a miss if the different literals change. remember that (again, unless i have misunderstood) we are not talking about compiled statements, but about linq generate the "complete text". i agree that the same plan would normally be used; the problem is hitting the cache to find that plan if the value of a variable changes.