The Pitfalls of Foreign Keys

  • Indeed.  Here's the single agreeable point made in this entire discussion, and it was gleefully overlooked by all but one.

    Ok, now two.  Whenever you have to consider the potentially dangerous approach (IMHO) to squeeze performance out of X amount of hardware vs getting more hardware to do it the RDBMS 101 way, your decision is placed squarely on the business.  Your preference is merely another variable in the equation.

    Hopefully, they get it right.

     

  • Clearly written article. You just saved me a bunch of testing.

    I'm deleting a M records from a table that is a FK to other tables that are equally large. This totally explains why it is taking forever.

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

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