Thank you all for your input.

I was able to resolve issue.

It wasn't a straight forward approach but it worked.

The problem appeared to be related to concatenating the result set of a view. I created a table and then ran the concatenation and my execution time went from 12 minutes to 9 seconds. Hugh difference!

Thanks again!

Ronnie