View previous topic :: View next topic
|
Author |
Message |
JyothsnaNayak
New User
Joined: 03 Feb 2010 Posts: 9 Location: India
|
|
|
|
When do we run Reorg on Index? Reorg on the tablespace also rebuilds the index on build space. So what is use of reorg on index?
Can anyone please let me know.
Thanks,
JSN |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
sometimes reorg index is all you need, and then there is no point in wasting time and cpu to reorg everything. |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
It depends what control card you are using...
REORG TABLESPACE - Reorganizes |all data and all indexes.
REORG TABLESPACE PART n - Reorganizes data for PART n of the table space and PART n of all partitioned indexes.
REORG TABLESPACE |PART n:m - Reorganizes data for PART n through PART m of the table space and PART n through PART m of all partitioned indexes.
If its a Partitioned table |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
GuyC wrote: |
sometimes reorg index is all you need, and then there is no point in wasting time and cpu to reorg everything. |
I like that type of thinking. All too often, people are just too lazy to make a little change to just do what is needed, and not all the stuff which "doesn't matter if it is done anyway" but which takes time. Then they sit there pressing enter every 20 seconds, hoping for a NOTIFY.
GuyC is off out the door with work done, whilst the "lazy" is still hard-at-it pressing enter :-) |
|
Back to top |
|
|
|