Hi,
I have tables in databases with avg_fragmentation of 86% and a page count of 26 and even less page count on some tables.I set up a job to rebuild and organise these indexes using Ola's script.There is no change after the job runs thrice successfully .the avg_fragmentation is the still the same.How can i solve this?
Thanks
checking your stats will get you the most mileage
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉