Sorry,

Wrong answer.

You are right.
Interbase and Firebird don't use index with distinct.

Sub query and distinct is more slow with a lot of records.



ibrahim Bulut
Software Developer
Republic of Turkey

----- Original Message -----
From: "ibrahim Bulut" <ibrahim@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, September 17, 2002 1:22 PM
Subject: Re: [ib-support] Adding index does nothing to select disctinct


> Hi,
> You must create a descending index.
> CREATE DESCENDING INDEX INDEX1 ON TABLE1(FIELD1);
>
>
>
>
> ibrahim Bulut
> Software Developer
> Republic of Turkey
>
>
> ----- Original Message -----
> From: "Thomas Miller" <tmiller@...>
> To: <ib-support@yahoogroups.com>
> Sent: Monday, September 16, 2002 5:55 PM
> Subject: Re: [ib-support] Adding index does nothing to select disctinct
>
>
> > It seems that there is a lot of thread float in this one. I think
> > another person
> > already mentioned that if he where to move Jobs into one file, and
> duplicate
> > information into another (setting up a one to many), that would be a
> better
> > database design and would remove the need for this DISTINCT query.
> >
> > I agree, but in the mean time, he still has his problem :-) .
> >
> > lester@... wrote:
> >
> > >>What does this have to do with his problem???
> > >>
> > >>
> > >
> > >Why is DISTINCT required was my original question.
> > >
> > >OK making DISTINCT faster is one way of solving a speed
> > >problem, but other simple changes to the way of working will
> > >give even better performance improvements.
> > >
> > >There is usually more than one way of fixing a problem, and
> > >I like to try the alternatives rather than living with slow
> > >performance because I got the original design wrong. I have
> > >been there with job numbers and am just proposing an
> > >alternative approach.
> > >
> > >
> > >
> >
> > --
> > Thomas Miller
> > Delphi Client/Server Certified Developer
> > BSS Accounting & Distribution Software
> > BSS Enterprise Accounting FrameWork
> >
> > http://www.bss-software.com
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > 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/
> >
> >
> >
>