Disabling constraints

shajju · #1 (**permalink**) 07-19-09, 10:26

Hi

When disabling constraints, is it important to use 'keep index'?

Would appreciate a short explanation of the consequences if we don't use 'keep index'.

Regards
Sheraz

Littlefoot · #2 (**permalink**) 07-19-09, 14:41

Documentation says:

Quote:

When Oracle Database uses a unique index to enforce a constraint, and constraints associated with the unique index are dropped or disabled, the index is dropped. To preserve the statistics associated with the index (because, for example, it would take a long time to re-create it), you can specify the KEEP INDEX clause on the DROP command for the constraint.

KEEP INDEX is an option; it is not obligatory so ... read some more documentation, see what each option does and which one is the best in your case.

Internet Services

Web Development

Digital Marketing

Consumer Tech