ARe u using 8.1.6 , then check whether the primary key constraint or unique constraint was created deferrable .
If yes, u need to find out the reason from developers.
The reason unique performs better is because it uses less space , but now in 8.1.6 u can compress the indexes.




Reply With Quote