The reson behind this question was, I have oem setted to monitor the index fragmentation. Now is shows that there are a number of FK indexes need to be rebuilt to remove fragmentations. I know the rebuild for a regular index, but since this being the index on the foreign key index, how should I do.
Is disable of PK necessary/ just the disable of FK would fix?
I would really appreciate if, someone tell me the steps to take?