Interesting stuff. Thanks for posting the follow up. Clearing the cache as a mechanism for dealing with bad parameter sniffing is somewhat problematic. You might want to look to plan guides instead (since you won't be able to directly affect the queries themselves).