I did try it on dev and test and it ran good .i am attaching the results..
Based on results:
1.In excel spread sheet one that is marked in pink is a heap.but when i looked into the object_name it actually has 2 non_clustered indexes.
why is it showing as heap?
2.Executed: ALTER INDEX [PK_tb_ProductFab] ON [dbo].[tb_ProductFab] REBUILD
This is a clustered index .why is it altering clustered index ?
Also this table has a non_clustered index why is it ignoring that and only altering this primary key clustered index?
Remaining results(index rebuilding ) are good matches with the fragmentation results ....
Can you also tell me how much page_count should exceed to rebuild the index ?
Thanks for the help