Dictionary column indexing

In PolyAnalyst, one can index both dataset and dictionary fields.

Sometimes it is necessary to speed up the search in the dictionary field and the work of postprocessors as, in a hidden form, the user regularly addresses indexed columns.

Thus, in dictionaries, the Name field is always indexed. In addition to the Name column, in Companies, GeoAdministrative, HumanNames or Organizations dictionaries other fields can be shown as being indexed as well (which depends on a dictionary).

By default, the search in dictionary manager is performed on indexed fields, which speeds it up. If the search in a single dictionary is slow, it is recommended to make sure that the field you need to search in is indexed.

To check which dictionary fields are indexed, open the User settings, open the Working with dictionaries option and check the corresponding checkbox.

dict mark indexed

In this case, the IND mark will appear next to the field name:

dict ind mark

Note

Column indexing is supported for the following dictionary categories:

  • Companies

  • GeoAdministrative

  • HumanNames

  • Organizations

  • UserDictionary

By default, the search in the dictionary manager is performed on the Name column. When creating a dictionary, it is possible to choose a column which must be indexed.

dict new dict mark example

It should be bourne in mind that the indexing process takes some time during dictionary initialization and disk space allocation. Thus, it makes no sense to index all dictionary fields. It is advised to index only those fields which we plan to search for or use in postprocessing.

The same is applied to the Export to Dictionary node.

In user dictionaries, the Name column is set automatically, so it is always indexed.

dict new dict mark

Note that when creating new dictionaries of such types as Companies, GeoAdministrative, HumanNames, and Organizations, their columns will be indexed automatically.