manual indexing for update operation added