Posted - 07/10/2014 : 21:34:21
| Hi All,
At the moment I am tuning the indexes with high fragmentation ..I created a maintenance plan for rebuild /reorganize ( set the logic for fragmentation above 50% then I will do rebuild , otherwise I will reorganize ... fill factor = 80 . I also filtered by the number of page count.
noticed there is 1 index which is fragmented very quickly starting from 2 am until 7 am .
I did rebuild / reorganize every 2 am ( after log backup at 12 am)
I believe after rebuild it will become 0% but after 3 hours it will become 80% I guess...
I check the unused index data ( using the script ) and for that index i got this data :
User_Seek : 0
User_Scans : 16
User_lookup : 0
User_updates : 1.128.932
I wonder that I should just drop this index or keep maintain it with rebuild it AGAIN after a few hours later ...
Please kindly advice...thanks heaps