--- In firebird-support@yahoogroups.com, "Chooi-Ting" wrote:

> 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

Chooi-Ting,

I suggest you start by reading

http://www.catb.org/~esr/faqs/smart-questions.html

in particular the sections "Be precise and informative about your
problem" and "Be explicit about the questions you have". Then write
another question to this list with more information so that we
actually may be able to help you.

HTH,
Set