Tips & Tricks: Performance - Working with attribute indexes

Operational Services
Operational Services
April 6, 2020

Tips & Tricks: Performance – Working with attribute indexes

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:

  • Electro
  • Gas
  • District Heating
  • Sewer System
  • Water

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:

  1. Start GEONIS Administrateur
  2. Naviguate to the datasource and start the DB update module.
  3. 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.


Categories:
Archive
Open: 2020
2020
December 14, 2020

Opening hours during holiday season

November 30, 2020

Tips & Tricks: Reset window positions in GEONIS Administrator

November 2, 2020

Tips & Tricks: Working with the GEONIS Desktop Log

October 29, 2020

New Home Base for Geocom in Zurich

September 23, 2020

Tips & Tricks: Permitted Terms and SQL Functions by Database Type

September 21, 2020

Job-based Mutation Processing

September 2, 2020

What's new in GEONIS 2021?

September 1, 2020

"LISA" becomes "VertiGIS eGuide"

August 31, 2020

Tips & Tricks: Remote Maintenance – Customer care via remote session

August 11, 2020

Tips & Tricks: GEONIS server - Remove the "Delete" button from an attribute mask

August 5, 2020

VertiGIS International Utility Forum 2020 - Registration link & agenda

July 7, 2020

Webinar: Reacting to Political Conflicts with Innovative Risk Management Solutions

July 6, 2020

Tips & Tricks: Sorting of objects in relation box

July 1, 2020

VertiGIS Utilities in test deployment at customers' site

June 9, 2020

Mapcom Systems Joins VertiGIS

May 29, 2020

Tips & Tricks: Install ArcGIS Enterprise patches and updates

May 18, 2020

What is the value of open and standardized data models?

May 4, 2020

Tips & Tricks: Improve performance using feature auto-caching

April 30, 2020

First pilot trials with DM.flex data model

April 6, 2020

Tips & Tricks: Performance - Working with attribute indexes

April 6, 2020

Tips & Tricks: Performance - Working with spatial indexes

April 2, 2020

Trainings and workshops via remote session

March 30, 2020

Risk Management and Business Continuity based on COVID-19 Dashboard Data

March 17, 2020

Continental uses the RMBC module "Procurement" in purchasing

March 2, 2020

GIS as a catalyst for business processes

February 28, 2020

New Geocom Partner in Italy: GeoGraphics Srl

February 26, 2020

Tips & Tricks: Plot Studio - Work with several data frames

February 3, 2020

Tips & Tricks: Part three – Analysis tools for your WebGIS

Open: 2019
2019
December 19, 2019

Opening hours during holiday season

December 4, 2019

Release GEONIS 2017 Service Pack 2 now available

November 28, 2019

Tips & Tricks: ArcmapSpy on GitHub

November 25, 2019

GIS solutions for cadastral surveying in the focus of VertiGIS

October 29, 2019

Tips & Tricks: New version of Geocom license server coming soon

October 23, 2019

Acquisition of general drainage planning (GEP) measures in GEONIS Sewer System

October 21, 2019

Geocom and AED-SICAD develop new Utility Network solution

October 2, 2019

Richard Wiegmann Joins VertiGIS as President and CEO

September 25, 2019

Tips & Tricks: Part two – Software version specification for support cases

September 23, 2019

Red Dot functionality for inspection videos in WebOffice

September 19, 2019

Improved batch call for GEONIS Data Converter

September 2, 2019

New version of GEONIS Network Calculation available

August 27, 2019

Tips & Tricks: Performance enhancements on Windows 10

August 12, 2019

New telephone numbers as of August 26, 2019

August 5, 2019

Tips & Tricks: Part One – General information on Support Tickets

August 2, 2019

Support for ArcGIS versions

July 4, 2019

Tips & Tricks: GEONIS Data Quality

July 2, 2019

LISA: Interactive city maps in Zurich and Utrecht

June 3, 2019

Tips & Tricks: Export GEONIS data list into an Excel template

May 9, 2019

Geocom recognized by Esri for Utility Network Management Specialty

May 2, 2019

Creation guideline for GEONIS Sewer System

May 1, 2019

Geocom is now part of the VertiGIS family

April 29, 2019

Tips & Tricks: Merge mail with attributes from GEONIS

April 24, 2019

Geocom Tile Package Export Tool

April 17, 2019

Tips & Tricks: Ready for TLS 1.2?

April 16, 2019

Geocom Map Package Export Tool

April 4, 2019

AED GIS Holding GmbH acquires Geocom

April 3, 2019

ArcmapSpy - ArcMap Add-In for Feature Class and Workspace Analysis

April 2, 2019

Tips & Tricks: Spatial filter when exporting in GEONIS Data Converter

March 28, 2019

LISA Webadmin Application - Administration of ArcGIS Online or Portal für ArcGIS Secure Web Maps

March 20, 2019

GPS Status Check for GEONIS gear

March 13, 2019

Measuring Add-In for GEONIS gear

March 6, 2019

Geocom Database Management Tools for ArcGIS

March 4, 2019

New ArcMap Add-In for extensive and effortless DXF export

February 26, 2019

Integration of infra3D into WebOffice

February 2, 2019

Geocom GIS Circle | Extended 2019

January 28, 2019

New ArcGIS Marketplace Provider


Categories

Popular Tags