locked
CRM 2011 - New Clustered Index? RRS feed

  • Question

  • Hi,

    We have a custom entity and its default clustered index on the entitynameExtensionBase table is on the ID(PK) field. Users mostly search for this type of entity based on another custom lookup field (City). Is it safe to create a new Clustered index based on the custom field? As a result the default clustered index will be dropped. Will this cause problems in the long run? And is it supported?

    Thanks


    Darren Mercieca

    Thursday, June 1, 2017 9:25 AM

All replies

  • It is only supported to add new indexes, and not to remove existing indexes. Rather than creating a new clustered index, I'd create a non-clustered index on the field you search on, and optionally add to the index all the other fields that are returned by the query. Adding all the fields will give the best search performance (and better than a clustered index), though could slow down data updates

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Thursday, June 1, 2017 10:46 AM
    Moderator