Improving query performance
Most databases offer various indexing systems to enhance query performance. Ultipa GQL can be used to manage indexes within a graph.
Additionally, Ultipa supports high-density computing (HDC) graphs. More details will be provided later in this section.
Managing the property index
Property indexes can significantly improve the query performance.
Users can create and drop indexes. Ultipa supports individual, compound, full-text, and vector indexes.
Creating an index
To create an index, use the following syntax:
CREATE {INDEX | FULLTEXT} <index name> ON {NODE | EDGE} <node/edge type name> ( <property names> )
The following is an example:
GQL:
CREATE INDEX name ON NODE User ( username(10) )
This query creates an index named name using the username property of User nodes, indexing the first 10 bytes of username values. This index could speed up the searching performance when filtering with the username...
