Being tense won't help the experience but to be honest, I'd have a colonoscopy any day, rather than an endoscopy. I've had both a few times, and survived with no damage done. Just let the sedative take over. The doctor won't try to hurt you, in fact, will do his/her best not to. Honestly...