How effective can a stretch and sweep be?

I'll be 40 weeks in 5 days and my midwife is planning on giving me one. My question is to lady's who have had this done, im just curious if it really does work and is it painfull? I also got told that the more BH contractions you get the better the chance of it working?