Reviewing index fragmentation on the CRM database is an important aspect for monitoring the CRM organizations as high levels of fragmentation will badly impact the performance, the fragmented indexes can be sorted out by reorganizing or rebuilding.
CRM provides 2 scheduled jobs for Indexes management:
- Indexing Management: responsible for creating indexes for any quick find columns
- Rebuild Index: responsible for maintaining the indexes fragmentation by doing index rebuild
Although it is supported by Microsoft to manually create or rebuild indexes but it is a best practice to let the scheduled jobs mentioned above do these 2 functions, if you needed to create a new index for a searchable column just add it to the quick find view and the next time the index management job runs it will automatically create the index for you.