[minor change] print the current state of target revision detection
create indexes on tables of db