Hello,
We would like to understand in which scenario an index on a table will be rebuilt. Example if we have a table, which has two columns and one if it is indexed, which of the below operation trigger an index rebuild:
1. updating the value of the indexed column.
2. updating the value of the non-indexed column.
Thank you