SQL Server has caching, but it is really strange that it goes from 2 minutes to subsecond performance.
You can expect some performance improvement, but that is fenomenal. Care to share the query?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP