How to improve performance using attribute indexes. We would like to show you how to set them up and put them to best use.
Create attribute indexes to improve queries and OBMs
Attribute indexes can speed up attribute queries on feature classes and tables. An attribute index provides ArcGIS with another way to retrieve records from a table. For most types of attribute queries, it is faster to find a record with an index than to browse the entire table starting with the first record. This is particularly important when the field is frequently used, e.g. in GEONIS Object Relationship Rules (ORM).
With version 2017.2 of GEONIS we provide you with an update script for each of the following solution to generate attribute indexes on the most frequently used fields in object relations:
- District Heating
- Sewer System
You’ll find the update script in the folder .\media\<nom du media>\db\indexe for instance, for electricity:
To create these attribute indexes, proceed as follows:
- Start GEONIS Administrateur
- Naviguate to the datasource and start the DB update module.
- Run the update script
Caution, before executing this script please first check that:
- The indexes do not already exist on the feature classes (they would then be created again in a useless way), to do this open the properties of the feature class and click on the “index” tab.
- For enterprise databases (sde), ensure that no connection remains on the database as this generates locks that can prevent the script from running properly. Also make sure to use a connection with “proprietary” rights (OWNER) on the database schema.