Post reply

Constraints and Performance

  • July 22, 2003 at 9:59 am

    #106343

    I haven't been able to find any information on the impact of using constraints as far as performance.

    We would like to enforce some business rules using constrainsts. An example would be if Field X is changed from 1 to 0, then Fields D, Q, and R also need to be 0. Would something like this involved adding a lot of overhead when these kinds of updates take place?

    Thanks!

    David Shower

  • July 22, 2003 at 11:31 am

    #466454

    No, my guess is you would never see a performance problem from implementing CHECK CONSTRAINTs on a table. The benefits of enforcing the business rule integrity at the database level will outweigh any (miniscule) performance impact of the CHECK. I know that the CHECK CONSTRAINTs may affect platform independence, however, so if that's a concern, be aware of it...

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply