Indexing fields for performance - property_graph - Latest

Property Graph Getting Started Guide

Product type
Data
Portfolio
Enrich
Product family
Enrich Properties > World Addresses
Product
Property Graph
Version
Latest
ft:locale
en-US
Product name
Property Graph
ft:title
Property Graph Getting Started Guide
Copyright
2026
First publish date
2021
ft:lastEdition
2026-02-23
ft:lastPublication
2026-02-23T14:19:10.733000
L1_Product_Gateway
Enrich
L2_Product_Segment
Data
L3_Product_Brand
Precisely Properties
L4_Investment_Segment
Precisely Addresses
L5_Product_Group
World Addresses
L6_Product_Name
Property Graph

Create an index to ensure the table supports fast queries based on the class, primary key, and secondary key fields:

CREATE INDEX if not exists property_graph_202301_index ON my_schema.property_graph_202301_classx (class, primary_key, secondary_key)

Repeat this procedure for all files in the product.