Creating Index on nodes property

[Munmud]

Is there any way to create index on property of nodes/edges ? If so how to add an index. For example i have created nodes as below

SELECT * 
FROM cypher('Students', $$
    CREATE (:Person {roll : 25, age : 20})
$$) as (v agtype);

Now I want to create index on property roll how to do that ?
How to use the created index for faster query ?

[talhahahae]

I think by using create index clause on the property 'roll' of node 'person' you can achieve your target.

CREATE INDEX property_index ON "Person" (roll);

Above statement will create index on roll property of person node.

[hammadsaleemm]

To create the index you can use this commad as mentioned by Talha CREATE INDEX ON :Person(roll), and to speed it up , I think you can use cypher queries like

MATCH (p:Person)
WHERE p.roll = 25
RETURN p

With the index in place, this query should run faster than a similar query without the index.

[waleedahmed0001]

To create an index on the "roll" property of the "Person" node, you can use the following Cypher query:

CREATE INDEX ON :Person(roll)

If you want to retrieve data based on this index, you can use this command
MATCH (p:Person) USING INDEX p:Person(roll) WHERE p.roll = 10 RETURN p

This query uses the index on the "roll" property of the "Person" node to quickly find all nodes where the "roll" property is equal to 10.

[humzakt]

Kindly have a look at this issue as it has alot of examples on creating uniques indexes: #45

[Hamza-Mushtaque]

Yes, It is possible to create an index on properties of nodes/edges in Apache AGE.

Try using the following Cypher query:

CREATE INDEX ON :Person(roll);

This will create an index on the "roll" property of the "Person" nodes.

And for using the created index for faster query USING INDEX clause in your Cypher query can be utilized.

For example, to find all the "Person" nodes with "roll" property value of 25 using the index, try using following query.

MATCH (p:Person)
WHERE p.roll = 25
USING INDEX p:Person(roll)
RETURN p;

In this query, the USING INDEX p:Person(roll) clause tells Apache AGE to use the index on the "roll" property of the "Person" nodes for faster lookup.

I hope this helps you.

[kenwoon]

I've tried the suggestions but none of them worked. From the following input:

SELECT *
FROM cypher('Demo', $$
    CREATE INDEX ON :Person(roll)
$$) as (v agtype);

I get an error that says ERROR: syntax error at or near "ON".

[WendelLana]

You can use the following command to create GIN indices:

CREATE INDEX index_name
ON graph_name."Label" USING gin (properties);

This GIN indices normally improves WHERE clause performance. Here is an example:

CREATE INDEX load_city_gin_idx
ON cypher_index."City" USING gin (properties);

SELECT * FROM cypher('cypher_index', $$
    EXPLAIN MATCH (c:City {city_id: 1})
    RETURN c
$$) as (n agtype);
                                     QUERY PLAN
------------------------------------------------------------------------------------
 Bitmap Heap Scan on "City" c  (cost=12.00..16.02 rows=1 width=32)
   Recheck Cond: (properties @> agtype_build_map('city_id'::text, '1'::agtype))
   ->  Bitmap Index Scan on load_city_gin_idx  (cost=0.00..12.00 rows=1 width=0)
         Index Cond: (properties @> agtype_build_map('city_id'::text, '1'::agtype))
(4 rows)

[Munmud]

You can use the following command to create GIN indices:

CREATE INDEX index_name
ON graph_name."Label" USING gin (properties);

This GIN indices normally improves WHERE clause performance. Here is an example:

CREATE INDEX load_city_gin_idx
ON cypher_index."City" USING gin (properties);

SELECT * FROM cypher('cypher_index', $$
    EXPLAIN MATCH (c:City {city_id: 1})
    RETURN c
$$) as (n agtype);
                                     QUERY PLAN
------------------------------------------------------------------------------------
 Bitmap Heap Scan on "City" c  (cost=12.00..16.02 rows=1 width=32)
   Recheck Cond: (properties @> agtype_build_map('city_id'::text, '1'::agtype))
   ->  Bitmap Index Scan on load_city_gin_idx  (cost=0.00..12.00 rows=1 width=0)
         Index Cond: (properties @> agtype_build_map('city_id'::text, '1'::agtype))
(4 rows)

@WendelLana After that how you will delete the index ? DROP INDEX index_name; not working here

[WendelLana]

@Munmud You have to provide the graph name, so use this command:
DROP INDEX graph_name.gin_index_name;

[Munmud]

Thank you @WendelLana