Here is the result of statistics io:

(60852 row(s) affected)

Table 'PRODUCT'. Scan count 2, logical reads 10, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0,...

GilaMonster (5/26/2012)

---

You sure you're seeing a delay from plan compilation, not SQL having to pull the data from disk vs cache? That query's simple, shouldn't take more than few ms...

declare @IdPackage as decimal

declare @IdFc as decimal

set @IdPackage = 394

set @IdFc = 15

set statistics io on

SELECT identitas_debitur

, SUM(isnull(ang_deb, 0)) AS ang_deb

, SUM(isnull(cost_bdi, 0)) AS...

SQL Kiwi (5/26/2012)

SQL Server automatically caches plans for reuse, so unless your query is recompiling often (or there's some other factor you haven't mentioned) there's generally no need to worry...

Greetings,

As I have just read this part of articles. A question arise in my mind 😀 about figure 5. As my I understanding after reading untill part...