SQL Server Analysis Services
Richard Kiessig · Apress eBooks · 2012
In the previous chapter, you saw how aggregation queries, such as counts and sums, can have a significant adverse impact on the performance of a database. The problems arise partly because of the time it takes the relational database to step through each row in the tables involved and partly because of an increase in memory use. If the aggregation requires scanning a large table or index, the process can displace other buffers from memory so that SQL Server has to read them from disk again the next time another query needs them. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.