I work in a database with a large amount of objects and Toad performance is poor.
See the following for reference.
Object Type |
Count |
Default or DEFAULT constraints |
35 |
Scalar functions |
1 |
Inlined table-functions |
1 |
PRIMARY KEY or UNIQUE constraints |
172,050 |
Stored procedures |
64 |
System tables |
45 |
Table functions |
2 |
Triggers |
19,039 |
User tables |
229,710 |
Views |
6,996 |