Re: how many LIOs is too many


Jonathan was spot on. As soon as I added an index on (maudrecno, memrecno)
in the test database the time dropped from 4:14 to 3 seconds.

I have copied and pasted the outputs from the dev environment:

Thanks for all the people who helped.


Other related posts: