fengzhongye

DEADLOCK! DEADLOCK! DEADLOCK!

7

## Bug Report ### Which version of ShardingSphere did you use? ``` org.apache.shardingsphere shardingsphere-jdbc-core 5.4.1 org.apache.shardingsphere shardingsphere-transaction-xa-core 5.4.1 ``` ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy? ShardingSphere-JDBC ###...

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

2

SELECT * FROM ag_catalog.cypher ( 'chunk_entity_relation', $$ MATCH ( n ) OPTIONAL MATCH ( n ) -[ r ]- ( ) WITH n, COUNT ( r ) AS DEGREE RETURN...