>Hello.
>
>Please consider this piece "code": Select * from ledger where orderdate >= ldLastDate
>
>If ORDERDATE field is an indexed field, will this be optimized by VFP?
>
>
>Thanks
Should be. Note that SYS(3054,11) might not show full optimization, depending on if you have a tag on DELETED() or not and/or your SET DELETED status. Whether you actually want (or need) a tag on DELETED() will vary, especially with how many deleted records your table will normally have in it.