I have a OE table with 41Million records, I have a primary index on one of the fields, which stores some valid values as well as some unknown values. I am doing a CAN-FIND using that field which has the primary index. I am doing the CAN-FIND for 80 records (80 times), I got a DB read of 5Million. Is it because I have unknown values in the index field ? If yes, is there any alternatives for fixing it ?
Is your primary index unique?
No it is not an unique index, it is just the primary index of the table
No it is not an unique index, it is just the primary index of the table
Create a unique index or try CAN-FIND (FIRST ....)
I am already using CAN-FIND(First ...) only, is there any other alternatives which we can try ?
The usual cause of reads like that the WHERE clause doesn't match any index.
In your case, if the index being used for the search has multiple unknown value entries, that could do it too.