Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    69

    Unanswered: db2 - Identity Question

    Hi,
    We are thinking of implementing the Identity solution for a table which can expect a volume of 75k applications created per day. This table has 5 children tables.
    I have few questions on implementing the identity,

    1. Is there any performance bottle neck of using the Identity for creating the Primary Key?
    2. Does this Identity key will get inserted to the child tables automatically when I throw the insert command on the parent table?
    3. Out of the 5 child tables 3 has other parent tables and different primary key. So if my question 2 is true, how does it happen in this scenario?.

    We are running db2 v8,FP 10 running on OS390.

    Regards,
    Anto.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    1) Depends on what you compare it against . (see some useful info below)

    2) No

    3) N/A (as 2 is no)

    If you are using a monotonically increasing value (like identify), then you may consider asymetrical page split in the index which will reduce the number of page splits.

    Have a look at RCT and see if it will suit you

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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