Hello Jerry

The only thing I can think of might not make anything faster
index on recno() tag recno

I don't know if you know but a SQL statement looks for a cdx (index tag) that will optimize the search

hope this is a plus


>Is there a way to improve the speed of this query?
>
>SELECT *
>FROM tablename ;
>WHERE RECNO() >= lnrecno ;
>INTO CURSOR mycursor
>
>I am trying to select the last X number of records from a table, but as the table grows, this SELECT statement slows down. Is there a way of improving the speed or another way to select just the last X number of records from a table?
>
>Thanks
>
>Jerryt