Hi Steve,

>I made a free table with two columns iValue and iDel (both integers). There are 500,000 rows in the table. With the following ASP I get a value the way I want it. However, it is much slower than having 50,000 rows in the table. Why? I have simple indexes on both columns.
>

you used:

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,