Re: Help with Disabling Constraints...

Bryan Hughes wrote: > > I am doing some performance tuning on our databases. One of the things I am > timing is our bulk loading with indexes, triggers, and constraints disabled. > I am having a problem disabling contraints in table mode. I am getting back > an 829 error indicating that the object is in use by other objects. I have > narrowed this down to the Primary Key contraints on the table. I assume > this is because this constraint is also a foreign key into another table. > So, what I am asking then is do I need to disable the reference constraint > on the child table that has this primary key constraint? Yes, you do . . . if you want to totally isolate the table from the rest of the database for loading, etc. Another means would be to load the table, then recreate indices and RI constraints. John Carlson Informix DBA WH Smith, Inc.