Having said that, if the dimensions of your data is much smaller when compared to the cache, the operation is likely for being carried out in memory. SQL Server also considers different optimizations if the server has more than one processor and if parallelism hasn't been disabled by making use of a MAXDOP trace or maybe the max degree of paralleli… Read More