feat: Implement write-only index state that is not considered for read queries

feat: Implement write-only index state that is not considered for read queries #6032