Obedience Training For Databases: Cascading Constraints

  • cbowman

    Valued Member

    Points: 72

    Am I missing something ( probably am), but I don't see how or why this is better than using a surrogate key and join clause. If it needs to be simple for queries, write a view.

  • Charles Kincaid

    SSChampion

    Points: 13593

    The point of the tiny fact table and foreign key is that to add new items is an INSERT. To change the check constraint you must drop the old check constraint and add the revised version back.

    ATBCharles Kincaid

  • John Corkett

    SSCrazy

    Points: 2038

    Neither do you need a join. In a view you would still be using a join.

    Thanks,

    John

Viewing 3 posts - 16 through 18 (of 18 total)

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