SQL Azure and Indexes

Question

is that true that SQL Azure rebuilds / reorganizes index automatically?

We have a database on Sql Azure and experiencing performance degradation and I suppose this is a urban-legend.

Can you help me?

Thanks, Marco

Answer 1

SQL Azure does not rebuild indexes automatically while the statistics are updated automatically. If you have a specific reason to force the rebuild it, you have to directly issue the command.

This nice post helps you create a script to dynamically rebuild all indexes in a SQL Azure db.