Interesting, doing your query in the IDE (where I can see SQL timing), having no index on either column excutes ~.98 seconds every time, but with an index it's 1.0n-1.1 for the same query.

Doing mine was around 1.9 with indexes set and 1.6 without.

Time to try Vlad's idea...


>

>Select iValue from UniqInt02 Where iDel=0 Order by iValue Top 1
>

>
>Why not use this one instead?
>
>

>Select min(iValue) from UniqInt02 Where iDel=0
>

>
>hth,