1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

About Constraints

Discussion in 'SQL PL/SQL' started by shanmugavel, Apr 26, 2012.

  1. shanmugavel

    shanmugavel Guest

    Enabling the Contraints in Database taking more time compare with disabling the constraints. What would be the reason.
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Disable operation Just disables the contraints and It doesn't need to check for its validity.


    But when you enable it again It has to ensure that all the data present it tables holds good against the corresponding constraint. It will try validating the constraint for each and every record.