Yes. But noone know which index will be used - fil_total or fil_subtot. To assure that exact index used, take opposite field into '()' so it will be used as expression.
>Can someone let me know if the following is optimized?
>
>scan for filename.fil_total = filename.fil_subtot
>
>I have an index on total.
>
>Thanks
>Pat Murphy
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.