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/
>
>
>