VFP doesn't look for an index on ORDER BY. It orders the result.


>Why it can not take top 100 records from the Index and then grab corresponding records? I don't know VFP internals, so I don't know if TOP is optimized or not.
>
>In SQL Server Index can be used for ORDER BY.