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

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...