update indices of tweets table