I’m sorry for the slowness. We can reproduce and see the difference like you indicated in some of our databases.
In 6.5 we use the new query because we try to improve performance for a database which has more than 20000 Users. It used to take around 4 minutes to expand the Schemas node and we improved it to 10 seconds.
Apparently that’s not your case. In one of our testing 10g database, we can find running the new query is slower than old. Because the time is too short(0.3sec & 0.9 sec)we could not tell much difference by experiencing. You surely can notice the difference as one of them takes more than 1 min. It would help us to optimize and verify the query if we can set up an environment similar to yours. Could you provide the information below: Database version? How many Users in the database? How many objects(select count(*) from sys.all_objects)? How many schemas under All Schemas node?
I’ll keep work on this and I hope we can provide a version which nicely works for all database.