Query Performance/Tuning on 10-15M nodes

Hi All,

Need suggestion on writing the performance optimized query on database which contains 10-15M nodes

Thank you,
M Mahendran


thats a very wide open question and hard to even suggest where to start

Do indexes provide any benefit?
Have you configured dbms.memory.heap.init_size and dbms.memory.heap.max_size appropriately? And dbms.memory.pagecache.size ?

see Performance - Operations Manual