Re:

> Did you try these queries from IBExpert? What statistic it showed?
> Did you try isql? How remote is your remote server?
> So far my best guess is that your server is extremely remote, and
> your application is extremely bad.
>
> SY, SD.

Thanks for you response.

The query in IBExpert is acceptable.
How do I check for statistics?

All other tables work okay when queried. And as explained only the first time I query using a dataset it is slow, the second time it is fast.

How to query using ISQL?
The remote server is in the US, on a Virtual Private Server (VPS) hosted by HostMySite.com, it is running CentOS.
We are in South Africa.
Some queries are fine, these two tables are not.