Connecting to PeopleSoft running on Sql Server

The PeopleSoft database is 480GB and contains 71,312 tables in production.

I agree with you that TDP is very quick with all of my Sql Server databases, except for PeopleSoft. With the ODBC connection it connects quickly and even with a filter on tables as soon as I click on the tables it hangs for 30 minutes. Below is what one of my DBAs found on the query that is executing during the 30 minute connection time. I cannot include the SQL code in the post but an more than willing to email it.

If you comment out/take out the piece of code that calculates [RowCount] column in SELECT list, the query executes in 5 seconds. It is kind of understandable, since for each returned row in main query (71,312 rows for this db) it is executing another correlated SELECT, which in its turn being executed 71,312 times.