I have created a non-unique, non cluster index in one of the table. But when I run the query in my database
select * from sys.dm_db_index_physical_stats(db_id('Inventory'),null,null,null,null)
I can see that there is avg_fragmentation_in_percent of 75 for the newly created index. Ideally it should not have any fragmentation. Even after rebuilding and reorganizing the index also, the fragmentation is not getting reduced. It is showing the same.
Can anyone please explain me the reason?
//All our dreams can come true, if we have the courage to pursue them//