I have a question on the extent fragmentation. How can I get the percentage of extent fragmentation down?
For example I have an Index on the G/L Entry table ($4) , logical fragmentation 0%, Extent fragmentation 27.27%.
When I do a rebuild on the index the number remains the same. So I tried to drop the index and create it again. Then the fragmentation goes up to 56%.
But when I do rebuild it again, the fragmentation goes back to 27.27%
How severely does the extent fragmentation influence performance?
Thanks in advance for any suggestions,
Fostering a homeless, abused child is the hardest yet most rewarding thing I have ever done.