Guide on optimizing joins on cross-cluster tables for a .NET data ingestion tool design

[srinipi]

I am trying to find any guide that can help in writing optimized queries for kusto,

Requirement- trying to design a C# client app, for performing queries analysis of data spread across multiple clusters, and ingest the summarized results into a results kusto table

Sorry for the vague ask, but any general guide, or already solved scenarios, if any I can design my application better

[#2]

some relevant (generic) docs:

https://docs.microsoft.com/en-us/azure/kusto/query/best-practices#join-operator

https://docs.microsoft.com/en-us/azure/kusto/query/joincrosscluster

if you need more specific help, please share more information about the queries you're running