Thanks Prasanth, It would be nice to see the flip side of issuing queries like " give me all accounts or persons" how do we optimize those compared to SQL.
Hi Naveen, you can run aggregation queries in Cypher like you might do in SQL (avg, max, min with group bys), though in those cases, the benefit of Cypher is not as apparent. SQL does the job great in those cases. Not to mention that analytical databases and query engines that implement SQL likely have many optimizations in place already for these use cases.
Thanks Prasanth, It would be nice to see the flip side of issuing queries like " give me all accounts or persons" how do we optimize those compared to SQL.
Hi Naveen, you can run aggregation queries in Cypher like you might do in SQL (avg, max, min with group bys), though in those cases, the benefit of Cypher is not as apparent. SQL does the job great in those cases. Not to mention that analytical databases and query engines that implement SQL likely have many optimizations in place already for these use cases.