What is better "find with and" or "find with

, ,
1

if I have a search buffer “AA,5,P,D,B9,4,P,GT.” where the first condition brings me one or 2 registers and the second condition brings me 50000 registers, then the best thing to do is using the search buffer “AA,5,P.” (FIND FILEXXX with aa=“WWWWW” WHERE B9 GT “9999”). With this the I/O of ASSO would be very low. Is it Correct?

Thanks by the attention
Edson Yuta

2

Yes, you are correct.

In this type of situation, the WHERE performs much better than the AND.