Flexible Sigmoidoscopy- sedatives, necessary or not?

Hi All,

I've got a flexible Sigmoidoscopy on Friday, been told I can choose if I want the sedation. Anyone had it without? How bearable is it?? Would make life a lot easier afterwards (childcare etc) 

Thank you