Hello, Here is my PLAN
PLAN SORT (SORT (JOIN (TR INDEX (IDX_TREE3_2, IDX_TREE3_3), ART INDEX (RDB$PRIMARY2)))) An VanderLinde --- In [email protected], "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 >
