On Thu, Mar 2, 2023 at 10:08 AM Laurenz Albe
wrote:
> On Thu, 2023-03-02 at 15:53 +0800, Navindren Baskaran wrote:
> If the other column is updated, it depends. If the updated column is not
> indexed and there is enough room for the new row version in the same
> table block, the index doesn't ha
On Thu, 2023-03-02 at 15:53 +0800, Navindren Baskaran wrote:
> We would like to understand in which scenario an index on a table will be
> rebuilt.
I assume that you are meaning "updated" or "modified" rather than rebuilt from
scratch.
> Example if we have a table, which has two columns and one
