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 ?

I bet a "select * from yourtable" is very fast. So I don't see the problem?

If there _is_ a problem - you should start describing it before we can help
you.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com