Hi Caroline,

Because there's nothing to optimize. VFP has to scan(read) whole table in this case.

>Many thanks to you both for clearing that up for me.
>
>As an aside why does a view with no filtering and just 1 table come back with no optimisation?
>