InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comFri, 05 Sep 2008 10:27:38 GMT20http://www.teradata.com/teradataforum/Topic9607-22-1.aspxMy guess: Query B benefits from use of the aggregate cache. The degree of benefit can depend on how much memory is available for this query and in what order the rows are aggregated. Other queries may be using part of the cache. Rows could be processed in a different order due to use of SyncScan, contention, or just tiny variations in I/O timing between runs.Sat, 03 Nov 2007 19:22:36 GMTFred Pluebellhttp://www.teradata.com/teradataforum/Topic9607-22-1.aspxI am comparing two queries for performance. Version "A" is the old one and version "B" is new and improved.I've run version "A" 10 times and version "B" ten times. All the runs from version "A" are identical sql and all of version "B" are identical. When I look in the DBQL spool usage I see that version "A" always has exactly the same spool use but version "B" has a varying spool use. It varies between 317,575,168 and 317,705,728 whereas version "A" is always 1,194,763,776.Does anybody know what might account for the varying spool use?ThanksFri, 02 Nov 2007 14:11:05 GMTjeff_o