db optimization: add indexes according to initial architecture