D&C painful?

Li

For those who have had a D&C, is it painful? Is it better than taking the pills to pass it yourself at home?