Hi Martijn,

Already do this:

CREATE UNIQUE DESCENDING INDEX "TT_CHA_DESC"
ON "TTALAO"("TT_SIG", "TT_PED", "TT_LOT", "TT_PRG", "TT_TAL", "TT_CCU"
);

In my execution plan i force this but is more slow than ascending
order...


Thanks,

Sandro.


--- In ib-support@yahoogroups.com, "Martijn Tonies" <m.tonies@u...>
wrote:

> Hi,
>
> Indices in Firebird are one-way only. That is, ASC or DESC. Try
> creating DESCending indices as well and see if that matters.
>
> Also, Firebird 1.5 (in beta right now) has quite some optimizer
> optimizations :)
>
>
> With regards,
>
> Martijn Tonies
> Database Workbench - the developer tool for InterBase & Firebird
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."
>
> >
> > Hi,
> >
> > I am with a problem that makes impracticable the continuity

of our

> project to use the Firebird as Database in the ERP developed for our
> company, the situation is this:
> >
> > In one table that we are using for tests with 500,000 rows
> approximately is necessary to return orderly ascending and

descending from

> determined combination of 3 columns, the tests are being

independent of

> components or access way, I use Firebird 1.0 Wi-v6.2.908 and I

execute the

> querys from IBConsole.
> >
> > Data for query:
> > TT_SIG = Company =´DEJ´
> > TT_PED = Order, Asked for =´0052652´
> > TT_LOT = Lot = 749
> >