Toad World® Forums

Improve Performance When Working with Database with a Large Amount of Objects

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