Microsofthello, i been advised by azure support to run this but I seem to be getting an issue where it wants to rebuild an index again and again on the same table, I think it is because of the partitions so it's detecting them but not specifying partition number is there any fixes for this?
e.g. when run I get
txtCMD ExtraInfo
ALTER INDEX [CI_Q_Net_xx] ON [dbo].[Q_Net_xx] REBUILD WITH(ONLINE=ON,MAXDOP=1); Current fragmentation: 98.37% with 184 pages
ALTER INDEX [CI_Q_Net_xx] ON [dbo].[Q_Net_xx] REBUILD WITH(ONLINE=ON,MAXDOP=1); Current fragmentation: 98.96% with 675 pages
ALTER INDEX [CI_Q_Net_xx] ON [dbo].[Q_Net_xx] REBUILD WITH(ONLINE=ON,MAXDOP=1); Current fragmentation: 98.87% with 177 pages
ALTER INDEX [CI_Q_Net_xx] ON [dbo].[Q_Net_xx] REBUILD WITH(ONLINE=ON,MAXDOP=1); Current fragmentation: 99.20% with 624 pages
ALTER INDEX [CI_Q_Net_xx] ON [dbo].[Q_Net_xx] REBUILD WITH(ONLINE=ON,MAXDOP=1); Current fragmentation: 98.82% with 762 pages
ALTER INDEX [CI_Q_Net_xx] ON [dbo].[Q_Net_xx] REBUILD WITH(ONLINE=ON,MAXDOP=1); Current fragmentation: 98.32% with 179 pages
ALTER INDEX [CI_Q_Net_xx] ON [dbo].[Q_Net_xx] REBUILD WITH(ONLINE=ON,MAXDOP=1); Current fragmentation: 98.88% with 179 pages
ALTER INDEX [CI_Q_Net_xx] ON [dbo].[Q_Net_xx] REBUILD WITH(ONLINE=ON,MAXDOP=1); Current fragmentation: 99.02% with 916 pages
