apache / apache/age

how to optimise this sql, its execution is extremely slow.

Open
#2,170 2 comments 0 reactions 0 assignees View on GitHub
question
Dominant language
C
Stars
4.8k
Forks
523
Avg merge
1d 2h
Merged PRs (30d)
9

Description

SELECT
*
FROM
ag_catalog.cypher (
'chunk_entity_relation', $$ MATCH ( n ) OPTIONAL MATCH ( n ) -[ r ]- ( ) WITH n,
COUNT ( r ) AS DEGREE RETURN n,
DEGREE
ORDER BY
DEGREE DESC
LIMIT 1000 $$
) AS ( n agtype, DEGREE agtype );

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.