Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    London, UK
    Posts
    14

    Unanswered: Enabling multiple constraints on a table in parallel

    Hi,

    I am considering enabling more than one constraints on a very large table(100m rows), at the same time. Is it possible? Will I run into read contention??

    This table has check constraints, not null and unique constraints as well.

    I was wondering if anybody had a similar situation and how did they go about it!!

    Thanks in advance

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Why wouldn't it be possible?

    It is obvious that you (and your table) lived without constraints till now; why didn't you enable them earlier - for example, when this table was created? 100 million rows is a large table; are you sure you'll be able to enable those constraints now? You might encounter foreign key problems (parent key not found, for example). But, if you know everything's OK with your data, I guess enabling them won't hurt.

Posting Permissions

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