> 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