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