Index fragmentation and size
ripteq
Posts: 4 Bronze 1
Hi,
I'm just trialling the SQL Index manager against some SQL Azure databases. After running the analysis I get a number of indexes listed as highly fragmented (98%) and large (3823138 pages). When I run the rebuild script and then analyse again, there is no change.
Did you have any thoughts or recommendation?
I'm just trialling the SQL Index manager against some SQL Azure databases. After running the analysis I get a number of indexes listed as highly fragmented (98%) and large (3823138 pages). When I run the rebuild script and then analyse again, there is no change.
Did you have any thoughts or recommendation?
