V,
When you look at the SQL Statement in the Execution Detail ~ is there a lot of Row Security appended to the end of your Data Selection.
We are, now, getting much better performance with some new indexes. If the users has significant Business Unit Security, then the Processing Hangs on the Data Selection (SQL Statement).
Due to the Bind Variables that are passed in from the UBE, there is some 'obfuscation' that takes place on the database. The EM would tell us the statement should run in a second, while the statement would take an hour.
Look at the timestamp of the Primary Select Statement, then look at the DS for the line(s) immediately following. That should tell you how long it took for the Select to Execute.
(db)