>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
If you create an index on recno(), it think Rushmore can kick in (I'm not sure, though).
However, it may be better to have a surrogate primary key field that you do this against.
Steve Gibson