Hi,

I have a table called history with the below attributes:
IPAddress int ,
RowId int ,
DateTime timestamp ,
RawSec int ,
RawUSec int ,
SeqSec int ,
SeqUSec int ,
CurrValue float ,
PresentState smallint ,
DataQuality int ,
FlagManuallySet char(1) not null,
FlagBlocked char(1) not null,
FlagControlInhibit char(1) not null,
FlagTelemFailed char(1) not null,
FlagTestMode char(1) not null,
FlagCalcFailure char(1) not null,
FlagLinkFail char(1) not null,
FlagPointFault char(1) not null,
FlagUnreasonable char(1) not null

Currently this table has about 22 million of records. The index has
been created on IPAddress, Rowid and DateTime. When I select from
this table, I encountered performance problem (as user complained
about it). I have no idea how to improve the performance. Can anyone
help ?

rgds