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,
Frank Camp