Online performance improvements via View-Indexe

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I have a custom FetchXml-Query with link-entities which seems to be much slower than all other queries.
I want to add some indices to my CRM Online system by adding the fields of required searchfields and link-entities in view definitions.

Now I'm wondering if there any differences regarding how indices will be created between adding the EntityReference field or choose the related entity and then add the Name field. Any hint about right behaviour?

E.g.
- Entity A with Field1, Field2, FieldRef to B
- Entity B with Name

View:
- Entity A with Field1, FieldRef
OR
- Entity A with Field1, FieldRef.Name

Thanks!

*This post is locked for comments

All responses (3)

Answers (0)

ashlega 34,475 on at

Like (0)

Report

RE: Online performance improvements via View-Indexe

Hi,

I am not sure what are those 5 indexes exactly, but it should be find columns, not view columns(since you can only perform a search on those columns which are added to the "find columns")
Community Member Microsoft Employee on at

Like (0)

Report

RE: Online performance improvements via View-Indexe

Thanks for pointing out and providing the TechNet-link.

The following sentence states that columns are used to build index, but not in Detail if this applies to 'find columns' or 'view columns'

"At least five new indexes are created whenever you create a new entity or reference a new column in a quick find"

Do you have some experiences/ advice here?
ashlega 34,475 on at

Like (0)

Report

RE: Online performance improvements via View-Indexe

Hi,

I believe the indexes are created when you reference a column in the quick find, not when you add it to any other view (so, to answer your question.. it probably wouldn't matter)

technet.microsoft.com/.../mt679036.aspx