I ran indexphysical stats dmv and found 4 rows for 1 clustered index with depth 4 row having 80% fragmentation. Even after runnning, ALTER INDEX [INDEX] ON [dbo].
REBUILD WITH (FILLFACTOR=90, online=on). Fragmentation remains at 100%.
1. How to reduce this fragmentation in Clustered index at depth 4(in general for all depth rows)
2. How to reduce frag for NC which too are at 100%