Mike Yearwood
Toronto, Ontario, Canada
>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.
Not faster than not having the index at all, especially when other filters have already identified the records.
>
>>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.
>>>
>>>
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only