The procedure itself will not be painful because your dentist will give you local or general anaesthetic before getting started.
You may experience some discomfort during the recovery process, but this will likely be mild, and can be managed with over-the-counter pain medication and ice.
Your dentist will provide you with detailed pain management instructions.