Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008

    Unanswered: Disabling constraints


    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'.


  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    Documentation says:
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts