My team is complaining that our CRM search function is too slow, so how do I optimize database indexing and search layouts in Dynamics 365?
Download run
Fan-out diagram
The searches the AI actually ran for this prompt.
SEED QUERY
My team is complaining that our CRM search function is too slow, so how do I optimize database indexing and search layouts in Dynamics 365?
2 real searches · 1 real-search pass
Badge and edge weight = share of passes that produced the query. Hover a query for its intent and routing format.
Query classes
Google's semantic query class for every sub-query: what kind of answer each search is after, simulated vs real.
Classifying 2 queries…
Searches and sources
ChatGPT2 real searches · gpt-6
Microsoft Dynamics 365 Dataverse search configure searchable tables columns quick find view performance documentation Google ↗
Microsoft Dataverse performance optimize queries views search columns indexing SQL indexes online documentation Google ↗
- Configure Dataverse search for your environment - Power Platform · learn.microsoft.com
- Configure Dataverse search for your environment - Power Platform · learn.microsoft.com
- FAQ for Dataverse search - Power Apps · learn.microsoft.com
- Search for records by using Dataverse search - Power Apps · learn.microsoft.com
- Use SQL to query data (Microsoft Dataverse) - Power Apps · learn.microsoft.com
- powerapps-docs/powerapps-docs/developer/data-platform/webapi/query/sql.md at main · MicrosoftDocs/powerapps-docs · github.com
- Search for Dataverse records - Power Apps · learn.microsoft.com
Queries
2 queries · click a column to sort
| Query / type | Search | Intent | Query class | Routing format | Cluster | Freq ↓ | Weight |
|---|---|---|---|---|---|---|---|
Microsoft Dynamics 365 Dataverse search configure searchable tables columns quick find view performance documentation OBSERVED | Google ↗ AI Mode ↗ | — | — | — | — | 1x of 1 | |
Microsoft Dataverse performance optimize queries views search columns indexing SQL indexes online documentation OBSERVED | Google ↗ AI Mode ↗ | — | — | — | — | 1x of 1 |