I am not clear on a concept of indexes.
Let’s say an index is created, but a lot of updates take place in htat column. How does an actual index pick up the values, since the index does not have the new values inserted into it, after the index creation.