>Hi,
>
>Couldn't an index be used to speed things up. In VFP if the SQL is stated exactly like the index syntax, doesn't VFP's rushmore technology kick in. I don't have alot of experience with MSSQL but it would seem like an index could be use their as well to speed things up.
>
>Leland

Yes, you're right in general. However if you want to get last 10 records for a condition that returns 10% of the table than indexes wouldn't much help because Select would have to get those records into the record set, order them and only after that take 10 of then as a final result.