----- Original Message -----
From: "David K. Trudgett" <dkt@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, December 07, 2001 2:32 PM
Subject: Re: [ib-support] Specifying a plan


> 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
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>