Indexes

Select entity properties to index on this panel and specify whether to apply case sensitive (exact) or case insensitive indexing for the selected entities.

This panel is expanded when you click the Indexes button on the Write to Model stage canvas. Indexing properties results in faster response times when the fields are queried, and some search options work only on indexed fields. Unindexed properties may be queried, but response times will be slower. On the other hand, indexing every field in a model reduces the performance when writing data to the model. To maximize overall performance, one can index fields likely to be searched and not index fields that are less likely or unlikely to be queried.

Property

This column shows entity properties defined in the model.

Type

This column shows the data type for a property.

Index Type

In this column, choose whether to index a property. There are three different options.

None—Choose this option when a property is unlikely to be queried often.
Exact—Search results must exactly match upper and lower case characters in the indexed data. Choose this option to index when for more precise search results.
Case Insensitive—Search results do not have to match upper and lower case characters in the indexed data. A case insensitive index typically returns more results than an exact search.