Hi Martijn,

>Then don't ask for them "all at once" :-)

>Seriously, you're asking the server for a complete resultset which
>needs to be prepared.

SELECT FIRST 1
A.*,
B.DESCRIPTION
FROM
TEST_DETAIL A
/*
LEFT JOIN
*/
INNER JOIN
TEST B
ON
B.ID = A.FID
ORDER BY
A.CODE,A.VNR

I added FIRST 1 to both queries and got the same results. The left
join is slow because it doesn't use UC_TEST_DETAIL_CODE_VNR and i
would like to know why?

>He sure does.

U got his addy, mine seems offline a loooong time ago :)

Greetings,
Filip Moons