After index rebuild, need to execiute a REBUILD or not

renjith · New User Joined: 07 Aug 2006 Posts: 11

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

kutty.r · New User Joined: 22 Jun 2006 Posts: 24

rebind it

renjith · New User Joined: 07 Aug 2006 Posts: 11

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..

Karthik Chandrasekaran · New User Joined: 21 Aug 2006 Posts: 8

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