T
TheMadDBA
Guest
I don't know if it is specifically spelled out in the docs that USE-INDEX will cause the query to use one index exactly one time, but it is certainly implied in the function name. It has certainly worked this way since the introduction of USE-INDEX. If you check the XREF you will see that the version without USE-INDEX will show 4 SEARCH entries for that index, because Progress is using that index 4 times. With USE-INDEX the XREF will only show 1 SEARCH entry. The documentation could certainly use more detail on the evils of USE-INDEX, especially about how it will not magically break the indexing rules to force proper usage of that index.
Continue reading...
Continue reading...