Has anyone had a hysteroscopy before?

Ni

Has anyone ever had a hysteroscopy before if so was it painful? How soon after were you able to have sex? Did you take anything beforehand to ease the pain? I have had an HSG in which my Dr. Said would be painful however it didn't hurt at all. So I'm wondering if the hysteroscopy will be the same pain wise.