how to optimise this sql, its execution is extremely slow.
Open
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
Assessment
This issue has not been assessed yet.