IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 - INDEX & Table updation


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
bakarthikeyan

New User


Joined: 21 Sep 2005
Posts: 6

PostPosted: Tue Nov 29, 2005 7:10 pm
Reply with quote

Hi,

Please let me know, if i am updating values for a particular table, Is it I have to update the Index also for that table?
Back to top
View user's profile Send private message
andy6703

New User


Joined: 25 Jul 2005
Posts: 14

PostPosted: Wed Nov 30, 2005 2:12 pm
Reply with quote

Hi bakarthikeyan,

Any change u make to the table that requires a change to the index will be done automatically & u need not explicitly invoke the change. Moreover only a change in the form of an insert or delete will require a change in the corresponding index component.

Hope this helps. Please add on or correct if necessary.
Back to top
View user's profile Send private message
bakarthikeyan

New User


Joined: 21 Sep 2005
Posts: 6

PostPosted: Wed Nov 30, 2005 5:28 pm
Reply with quote

Thanks Much Andy
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
No new posts Dynamically pass table name to a sele... DB2 2
Search our Forums:

Back to Top