Posts Tagged ‘indexed view’

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 […]