Only within a session unless something has changed there, that means no sharing between clients or even from one connection to the next form the same client.
MSSQL caches plans globally and can be used across sessions and connections if the statement text is the same.
SigmundA|2 years ago
MSSQL caches plans globally and can be used across sessions and connections if the statement text is the same.