View previous topic :: View next topic
|
Author |
Message |
renjith Warnings : 1 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 |
|
Back to top |
|
|
kutty.r
New User
Joined: 22 Jun 2006 Posts: 24
|
|
|
|
rebind it |
|
Back to top |
|
|
renjith Warnings : 1 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.. |
|
Back to top |
|
|
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 |
|
Back to top |
|
|
|