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?

I'm also curious to know how this indexing work?

Mr. T