View previous topic :: View next topic
|
Author |
Message |
kishpra
New User
Joined: 24 May 2010 Posts: 92 Location: Pune
|
|
|
|
Hi All,
I want to create a DB2 table which will have columns like Emp No, Seq No, Acct No, Rate, Hours Worked, etc. This table will be loaded monthly using an input file which will have Emp No, Seq No and Acct No same and other values getting changed/updated OR New Emp No, SeqNo being introduced.
I want to append the new data everytime it is loaded.
Please let me know how to come up with Key (Primary key) definitions along with the indexes for defining this table. |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
Ask your DBA - indicies depend on usage. |
|
Back to top |
|
|
kishpra
New User
Joined: 24 May 2010 Posts: 92 Location: Pune
|
|
|
|
Thanks Nic.
Can you please let me know some of the things that needs to be taken care when defining a table without primary key since the data needs to be appended every time. Also how to come uo with indexes for the same to improve the performance. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
I think re-read the first three words of Nic's response.
What you are doing, how you are doing it, and whether you should be doing it, and how it fits into your DB2 is all related to your site. |
|
Back to top |
|
|
|