Disable\enabled Constraint

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mujtabait
    New Member
    • Aug 2016
    • 1

    Disable\enabled Constraint

    Hello Everyone

    I hope this article find all of you in good health.
    i have disabled some of the constraint deleted some data and enabled it back using:
    ALTER TABLE table_name disable CONSTRAINT constraint_name
    ALTER TABLE table_name enable CONSTRAINT constraint_name ;
    now when i check in Enterprise Manager the graph for User I/O and Commit is too high.
    Our database is so slow and cant save.
    the attached file is our graph after 4:40pm no one is using therefore graph is low now.
    Please advice me what to do
    Thank you
    Attached Files
Working...