>Hi,
>
>I have a huge table. Before data processing I create temporary index:
>
>Select 0
>Use SERV
>Index On ENUM+STR(SNO,2) For BATCHDATE=ldDate To Temp
>
>How can I know how many records were filtered ?
>
>Sincerely, Igor Gelin
Normally _TALLY will return it after INDEX. However, it was reported recently that it's not reliable, so you can fortify it by using COUNT or SELECT-SQL with _TALLY.
Edward Pikman
Independent Consultant