On Friday 2001-12-07 at 14:19:53 +1100, David K. Trudgett wrote:

> Hi all,
>
> I have a couple of queries (see below) that I would like to speed up.
> I could do it using two queries, but that would necessitate some other
> design changes to the application (not a big deal, but I'd prefer not
> to have to touch it).

Actually, I found the problem was a missing index in the database. The plan
that InterBase came up with was:


PLAN JOIN (SREGHSUB INDEX (IN_HSUBCHESSHIN),TBLSREGMAST INDEX (RDB$PRIMARY5))


which was eminently sensible, and returns a result in under 0.5 seconds
(seems instantaneous).

Sorry if I wasted anyone's time.

Regards,

David Trudgett