is it necessary to reload all segments associated with this table to see a performance improvement in the query execution on this column?

In general any change in the indexes require to reload the table in order to be able to use it