For select statements like
select * from table where indexed_col='abc';
sql would go to index table and fetch row address and return required. But what about dml statements like
update table set indexed_col='abc' where condition;
how is consistency ensured between table and indexed table?