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

LEAVE A REPLY

Please enter your comment!
Please enter your name here