Re: Stored Procedure runs long the first run, then runs faster

Compilation of a stored procedure takes some milliseconds.

I guess it's more related to buffer pool = SQL Server data cache, see 

Memory management architecture guide - SQL Server | Microsoft Learn