Hello,

Here is my PLAN

PLAN SORT (SORT (JOIN (TR INDEX (IDX_TREE3_2, IDX_TREE3_3), ART INDEX (RDB$PRIMARY2))))

An VanderLinde

--- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@...> wrote:
>
>
>
> > Hello,
> >
> > I have a problem with the speed of a query in Firebird. The slowness is in the
> > sorting and distinct.
> >
> > If I try the query in MySQL then he is one second faster.
> >
> > Firebird -> 1,3s a 1,6s
> > MySQL -> 0,3s a 0,4s
> >
>
> Please post the PLAN used for the query
>
>
> Sean
>