Indexes in output of Query " call dbms.listQueries " showing nothing even though index is defined

Neo4j Graph Platform Cypher
1

Hello Team,

I have observed that in output of "call dbms.listQueries" , Indexes column is coming blank even though I have already created index in the query which is running in background.

Please let me know on how to check whether the index is used while running the query which is using index.

Thanks
Akshat

2

Use Explain before the query to know if the query hits index or does full scan

3

Hi Vivek,

Actually I am trying to load the data from Oracle db . Below is the snapshot of the explain prefixed with my query. Let me know if it is using index or not.

image
image1222×380 17.1 KB

Regards
Akshat

4

Dear @akshat_mittal

Index is DB specific. So I case you are using Oracle DB. Then you need to create index at Oracle and though Orcale Explain or Execution Plan you can check if index hit happened or not while fetching data from Oracle

5

Hi Vivek,

Thanks for your quick reply.

So what I understand is - Index needs to be created at the Oracle DB end. ( destination DB ).
Please confirm.

Any screen shot u can share which neo4j internally uses index.

Regards
Akshat

6

Hi Akshat,

As per I understood you are trying to fetch data from Oracle and store into Neo4j. Am I right?
And for that you have fired Select statement at Oracle and then using Create/Merge to ingest data into Neo4j..
If above is true and in the Select statement you have where clause then it will be better to create index at Oracle.
Syntax: create index <index_name> on <table_name> ( <column1>, <column2>, … );

7

Hi Vivek,

Yes !! Your are correct.

I am trying to fetch the data from an oracle view and loads it into Neo4J using Merge statement on primary key in neo4j. Oracle Query contains - select *from view name where column name = 'update'.

So index should be at that column name in oracle.

Best Regards
Akshat

8

Yes Akshat you are right

9

Ok Vivek!

Thanks a lot!