T
TheMadDBA
Guest
One thing is that once Progress decides to use a word index it will not use other indexes to satisfy the query. Just the word index (unless you have an OR). I also had better luck in the past using a field identifier in the word indexed field so instead of "A B C" it would be "Status@A Region@B Rep@C". Grab one of the problem where clauses and compile/run it in the editor and look at the XREF and the _UserTableStat/_UserIndexStat values and see exactly what is happening.
Continue reading...
Continue reading...