View previous topic :: View next topic
|
Author |
Message |
Shaheen Kalokhe
New User
Joined: 21 Feb 2008 Posts: 21 Location: India
|
|
|
|
Hello,
I would like to know the advantage of Updating a record using its DB Key
instead of CALC key. Does anyone has any idea of the time saved by using Db key based updates.
Thanks
Shaheen |
|
Back to top |
|
|
puviarasu
New User
Joined: 10 Mar 2008 Posts: 4 Location: India
|
|
|
|
Updating a record using DB-KEY is advantageous since the DB-KEY is the address of the particular record. Its the Page number + line number of that record. So if you try to update a record using the DB-KEY it will locate the record using this key value which is straight forward.
But when u update the same record using the CALC key, it should locate the record based on the calcing logic... which might require few more operations and consume more CPU time... which will be slightly slower than the first one... |
|
Back to top |
|
|
Shaheen Kalokhe
New User
Joined: 21 Feb 2008 Posts: 21 Location: India
|
|
|
|
Thanks for uri reply puviarasu
But what exactly i am looking for is the time difference. I already know that update using DB-Key is efficient. If ua have some details pertaining to time pals do reply.
Thanks
Shaheen |
|
Back to top |
|
|
puviarasu
New User
Joined: 10 Mar 2008 Posts: 4 Location: India
|
|
|
|
I don't have the detail regarding the time difference for this particular scenario. I can suggest one thing while coding a batch program we can retrieve the TIMESTAMP before and after the execution of the DML statements(bulk) using the DB-KEY/CALC-KEY which might give the time difference. |
|
Back to top |
|
|
|