The test is performed under sedation and most patients have no recall of the procedure at all. It is important that you do not drive for at least 12 hours afterwards and you must have someone to take you home after the procedure.
Colonoscopy is currently the “best” screening tool for colonic pathology although there is a limit to its sensitivity and rarely small lesions (usually of no consequence) may be missed.