Walter Meester
HoogkarspelNetherlands
General information
Category:
Coding, syntax & commands
>>>>Does anyone use binary indexes?
>>>>As ?
>>>
>>>Not here... unless the index is very skewed leaving only a few records with the values you're searching for, it is not of much benefit
>>
>>I do not know how to use them.
>>SET ORDER and SEEK are not usable
>
>According to the helpfile those commands are not supported for binary indexes.
>Its only useful for rushmore for rushmore optizmizable commands like LOCATE FOR, BROWSE FOR, CALCULATE FOR, SQL SELECT, Etc
>
>And for that, in general, it is quite useles anyways, so I do not bother with it.
I think a better way to express it would be to say, benefit of creating an index on binary choices has to be questioned.
If there is a clear use case to filter on such distribution, "binary" makes such an index "profitable"
Previous
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