>>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.
Thanks, Ed.
What makes _TALLY un-reliable in this particular case?
Igor Gelin.
Igor Gelin
Database Developer