web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

D365 Online out of box index building feature and index customization for custom entities

(0) ShareShare
ReportReport
Posted on by
Hey Dynamics community.
Currently, I’m deeply involved in plugin development for the Microsoft Dynamics 365 Online platform. It widely uses the search queries so the search experience dramatically depends on search query overall performance. Thus, the search speed is crucial to use successfully the plugin.
Due to the lack of direct control under database, I’m looking for options to improve the search speed performance by creating indexes for both standard and custom entities. Otherwise, I generally ask if there’s any out of box feature to build indexes for entities. Questions:
1. How does it build an index for a standard entity (like email or task)? How can I trigger index (re)building for particular entity/fields? Is there an option to do that programmatically (through API)?
2. Does this build an index for a custom entity/field (even in case it's derived from a custom entity)?
3. What are timeframe and requirements to build an index?
4. Does the trial version of D365 support indexing?
Thank you for any help/assistance to answer this question.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    PranavShroti Profile Picture
    4,510 on at

    as you rightly said, database access is not allowed in Online, however earlier you could have added index to a field by adding that column as a result in the Quick Find view. Version 9 of Dynamics 365 is a very different system to previous versions and indexes are created automatically as the database wishes.

    There is a nice article by Alax on indexes in CRM: community.dynamics.com/.../dynamics-365-how-do-you-get-a-column-indexed-automatically

    Regards

    Pranav

    If found useful, please mark the answer as verified

  • Community Member Profile Picture
    on at

    Thanks. You lighted up the om D365 index building. Now testing the database if it schedules the timeframe of index building properly.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans