DDL slow, but DML fast.

Hello. We have an outsourced test team that is testing upgrade scripts from a previous version of our product to a later version. In the course of testing, they would remove multiple times the schema to be upgraded. Somewhere along the line, it turns out DDL operations have become slower and slower, to the point where it practically hangs. So creating users, tables, etc, gets to be practically impossible.

I looked at the script and I couldn't see anything that could possibly do anything, some table columns were altered, some tables were created, a few indexes are created, some are dropped.

I'm beginning to think that the script itself isn't to blame, and that they must have done something else to the instance that they overlooked. Does anyone have any suggestions at all as to what might be going on? Thanks. Received on Sat Oct 14 2006 - 14:12:04 CDT