T
tomas.kucera
Guest
Hi all, I have a question regarding the following query: FOR EACH customer WHERE customer.sales-rep EQ 'DKP' NO-LOCK BY name When I look at the indexes being used then only the Sales-Rep is there. When removing the WHERE it is the Name index. The combination of WHERE and BY thus causes that it performs server side WHERE resolution but the client side sorting. Both are single component. I have expected that both the Sales-Rep (for WHERE resolution) and Name (for sorting) would be used. The questions are: 1) Is this correct behaviour? 2) Can this be optimized, so it would perform server side sorting instead of client side? Not by using USE-INDEX! It is all under OE11.6. Thanks in advance! Kind Regards, Tom.
Continue reading...
Continue reading...