>Hi Jacques,
>
>I can't think of anything to explain why the query execute faster in the command box than in the program, but are you sure that your query is fully Rushmore optimizable? You can check this by issuing Sys(3054, 11) before the query.
That can usually occur if the SQL thinks it requires an index, and the second time in the Command Window, the index is already in memory...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
