Kerry

I am sorry, reading it fast gave me wrong understanding.

Eduardo

Kerry

Have you tried NOJOINOPTIMIZE ?

Eduardo

Kerry,

<< No problems - here is is >>

The join is un-optimized due to the fact that you've created
case-insensitive indexes on the join columns, but are asking for a
case-sensitive join.

Use this instead:

SELECT
 box.BoxNumber,
 box.ID
FROM
 box
 LEFT OUTER JOIN Import_OffsiteBoxes ON (UPPER(box.BoxNumber) =
UPPER(Import_OffsiteBoxes.Box_Nr))
WHERE
(Import_OffsiteBoxes.Box_Nr is NULL)
ORDER BY
 box.BoxNumber ASC

--
Tim Young
Elevate Software
www.elevatesoft.com

Hello Tim Young [Elevate Software],

> The join is un-optimized due to the fact that you've created
> case-insensitive indexes on the join columns, but are asking for a
> case-sensitive join.

Jeez! What a difference! It worked like a charm. The query went from 22 seconds
to 0.288 seconds!

Many thnaks....the boss will think I am brilliant!