Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
After index rebuild, need to execiute a REBUILD or not

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
renjith
Warnings : 1

New User


Joined: 07 Aug 2006
Posts: 11

PostPosted: Fri Aug 25, 2006 2:49 pm    Post subject: After index rebuild, need to execiute a REBUILD or not
Reply with quote

suppose i have one table with some rows of data.now suppose am adding one new indedx to the table.my doubt is after adding the index do we mnned to execiute a REBUILD or not

thanks
renjith
Back to top
View user's profile Send private message

kutty.r

New User


Joined: 22 Jun 2006
Posts: 24

PostPosted: Sat Aug 26, 2006 11:33 am    Post subject:
Reply with quote

rebind it
Back to top
View user's profile Send private message
renjith
Warnings : 1

New User


Joined: 07 Aug 2006
Posts: 11

PostPosted: Mon Aug 28, 2006 10:10 am    Post subject:
Reply with quote

thanks for ur reply..my doubt is whether we need a rebuild (not rebind--caz rebind is for chosing the new access path) or not..
Back to top
View user's profile Send private message
Karthik Chandrasekaran

New User


Joined: 21 Aug 2006
Posts: 8

PostPosted: Wed Aug 30, 2006 12:06 pm    Post subject: Re: After index rebuild, need to execiute a REBUILD or not
Reply with quote

You dont need to build the index explicitly if you have created the index without DEFER keyword.If you specify DEFER while creating the index, you have to build the index after creating the index.



Karthik
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Confusion b/w index and subscript Deepak kumar25 Mainframe Interview Questions 7 Thu Aug 31, 2017 6:50 am
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm
No new posts Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us