Does it hurt?

Just been told I have to be referred for one - not particularly looking forward it, but not really sure what to expect either. Doctor wasn't too helpful, except to say that it's not very comfortable!