I think this wipes out the stats : AND I.is_hypothetical = 0

I'm not sure though, I have not done such tasks in a very long while.

Check out INDEX_PROPERTIES as well.