
Improve Performance by Disabling and Enabling Constraints
For most of us, working with large databases is a day-to-day activity. All too often, backup and restoration are considerably slow—usually because of the constraints imposed on the tables. Take a look at the following code: CREATE TABLE Contractors ( contractor_id numeric(5) not null, contractor_name varchar2(50) not null, CONSTRAINT contractor_pk