Server, by design, caches query plans for . For reuse of cache, the best practice would be to include the name in the query.

For example:

select * from dbo.accounts

This way, when this is cached, the cache can be reused by all users who execute this query.

Source link


Please enter your comment!
Please enter your name here