If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > index after inplace reorg

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-16-09, 07:31
db2aix db2aix is offline
Registered User
 
Join Date: Jul 2009
Location: USA
Posts: 50
index after inplace reorg

Will db2 be able to use the index if I don't reorg it following an inplace reorg?
Reply With Quote
  #2 (permalink)  
Old 09-16-09, 08:32
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
If you couldn't use the index, then an inplace reorg would be useless.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #3 (permalink)  
Old 09-16-09, 08:47
db2aix db2aix is offline
Registered User
 
Join Date: Jul 2009
Location: USA
Posts: 50
DB2 documentation about inplace reorg:
Indexes are maintained, not rebuilt, so subsequent index reorganization might be required


might be required -> how do I tell if index reorg is required or not?
Reply With Quote
  #4 (permalink)  
Old 09-16-09, 10:27
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
What they mean by "might be required" is that the indexes may be disorganized enough that they might perform better if reorg'ed. They are not suggesting that the indexes cannot be used by a query just because you did not reorg them.

This is in contrast to a offline reorg on a table, where the indexes are automatically reorg'ed (actually they are just rebuilt). So they are just trying to warn you that an inplace table reorg does not reorg the indexes.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On