>Incidentally, what happens if you clone the DB, drop all the data, leaving the schema intact, tables empty? Is it still slow? Jepp. >What if you drop half the indices? doubles the speed. >What if you drop the other half? doubles the speed. >or is it simply that the opening speed drops as a direct function of the number of indices? Not the "opening", is slow - that performs in < 10ms. It's the creation of the SQL statements that takes the huge time. And yes, the speed depends directly to the number of indices.