Using VStudio, I see several indexed fields (a few, not all) have a property named "FORCE_INDEXED" with value = 1.
What is the meaning/use of this property ?
Why some indexed fields have it but not other ?
Ok. But I thought, as I'm not a database expert, that I must set an index only when it's a sort/search frequently done. Sometimes the user can do a custom sort or search that is occasional. Do you say that I must set an index in this case ?