>>>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.
I don't remember (maybe nothing:), it was some thread on UT recently. You can search for it.
Edward Pikman
Independent Consultant