hysteroscopy

I am due to have a hysteroscopy  on Tuesday  next week .I have read on here some people have had to and it's not too bad other say it's really painful  can anyone tell me any more please I do need it doing as they suspect cancer as my womb is thickened so really worried now