Discussions

General J2EE: Limitations of Composite Keys in Table Designing

  1. Hi all,
      Can I get a Paper/Document on 'Limitations of Composite keys in Table designing'
      Designers now a days says to aviod Composite keys as much as possible.Instead of Using Composite keys use a Sequnce No as PK and validate accordingly whereever it is required. Is it true? If yes can I get details regarding this.
    Pls let me know in general when we need to go for Composite Keys and when to Single PK(Seq No).


    Regards
    B S Reddy
  2. Hi all,

    >   Can I get a Paper/Document on 'Limitations of Composite keys in Table designing'
    >   Designers now a days says to aviod Composite keys as much as possible.Instead of Using Composite keys use a Sequnce No as PK and validate accordingly whereever it is required. Is it true? If yes can I get details regarding this.
    > Pls let me know in general when we need to go for Composite Keys and when to Single PK(Seq No).
    >
    >
    > Regards
    > B S Reddy

    Hi all,
      Iam waiting for the Reply
    BS