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

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

Yes, you are correct.

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