I am planning to get a colonoscopy and I have a question?

I would like to know if I should get a doctor who will put me to sleep? Anotherwards is it painfull? Or would it be just as good to get a doctor who just puts you in the twilightzone? Thanks