Ever so often, queries include some aggregates data. In a datawarehouse environment, they are frequently used for metric and Key Performance Indicator (KPI) calculations. Aggregates are also used a lot for reporting purposes and for statistical computation. When a query perform poorly, our first instinct is to add an index to speed it up. Creating a […]
Posts Tagged ‘indexed view’
March 25, 2012 by Francois · 3 Comments
Filed under: Performance, TSQL
Social Tagging: Index • indexed view • join • query plan • TSQL • view
Filed under: Performance, TSQL
Social Tagging: Index • indexed view • join • query plan • TSQL • view
RSS