>I have a BIG database in SQL-Server 6.0
>I access the data with assynchronous and maxrecords = 10.
>When I asked for a sqlexec->[select * from table] the result lasts very long to return.
>Somebody knows what happenned, or what do I have to do to fix this poblem?
>I want to receive only the first 10 records fast.

Often times, if your query does not require SQL to use one of its indexes, or it can't use an index due to the type of filtering you are doing, it has to read the entire database record for record to answer the query. I'm not sure whether in finding the "first 10 records" that it doesn't have to read the database to make sure that what it got is the first ten.

HTH,


Bill