Press F1, and look up "INDEX Command"
>I will have to learn where and how to add the Binary keyword to the logical index. Thank you.
>
>>If you need an index on a logical field or on deleted(), make sure to add the Binary keyword when you create it. That will make the index much smaller, meaning much faster.
>>
>>>The more it makes sense for me to get rid of it. Thank you.
>>>
>>>>Any index on a binary value will generally not be very effective. I've heard some people say that an index on DELETED() is effective if you have a high number of deleted records, but never tested this myself.
>>>>
>>>>