Let's say I need to add a check constraint like below to employee table with 2 million records
My questions is :

What's the Rules of thumb , how much performance loose I should expect for each DML after adding this check constraint

How do I check the effects systematically before I apply this to Production environment



ALTER TABLE employees ADD CONSTRAINT check_comp
CHECK (salary + (commission_pct*salary) <= 5000)