"Skywalker" <stevenxiu@yahoo.com> wrote in message
news:eviqX6s$FHA.916@TK2MSFTNGP10.phx.gbl...
> Hi All,
>
> I am not sure if SQL200 or SQL2005 has cache function which can store the
> query result into cache.
>
> I have a large table T1 (C1, C2,...C20) with multi-million records and
> need to do a report from it per hour.
>
> Select C1,C2,C3, sum(C20),sum(C19) from T1 group by C1,C2,C3
>
> Most of the historied recodes ( 10 days ago) do not change frequently,
> however they do changes. Is there a way which can cache the report data
> for those 10 days old records and only run the query based on changes? It
> will greatly improve the performance.
>