The container_ncr join is needed to filter out unneeded data; I did create an aggregate index and sure enough it sped things up. The first time it is...

noel, I tried what you said, and it did seem to help! thanks for your speedy reply!

Mike, I originally did have separate columns and I felt that was what was slowing things down. Yes, I have indexes to support allthe joins. ...