• Any suggestion for that?

    In my table (340G_140000000Row) Most of reports run are against the most recent one year of data.My table has a clustered index(primary key) on 2 fields : [Number] [int],[TransDate] [datetime]. I created partition over [TransDate] and all the indexes ON DB_PartitionScheme ([TransDate]),but the logical reads of this table and cpu time increase in test db.

    I don't know why it is in this way?what should I do?