View previous topic :: View next topic
|
Author |
Message |
rathinakarthik
New User
Joined: 25 Jul 2006 Posts: 24
|
|
|
|
Hi,
We are having performance issues in our DB2 modules. We found that updation of columns of in a table is taking much CPU time. Currently the columns are updated in random fashion.
If the columns are updated in Clustering index order , whether the CPU time will be reduced?
Please advise
Thank you. |
|
Back to top |
|
|
kgumraj
Active User
Joined: 01 May 2006 Posts: 151 Location: Hyderabad
|
|
|
|
Hi,
You have the answer in your question. You are true CPU time will improve when you use clustering index. |
|
Back to top |
|
|
vini_srcna
Active User
Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
|
|
|
|
Quote: |
If the columns are updated in Clustering index order , whether the CPU time will be reduced?
|
Obviously yes. It takes less time when you go for sequential access. |
|
Back to top |
|
|
ashok_uddaraju
New User
Joined: 21 Feb 2007 Posts: 72 Location: US
|
|
|
|
hi,
The main purpose of clustering index is to reduce CPU time |
|
Back to top |
|
|
|