My pet peeve with Universe Indexes is in selecting multiple values of an indexed field
The following select might take 10 minutes SELECT CONTRACT WITH I_CONTRACT = "50178227" "50092158" "50006089" "50178228" "50092159" "50006090" "50178229" "50092160" "50006091" "50178230" Whereas SELECT CONTRACT WITH I_CONTRACT = "50178227" comes back immediately. I've had to create a utility to do the selects individually and combine the results in one list. When we upgraded to 10.1, I had hoped that the process would be quicker, but it's the same ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
