Detailed table explaining when to use JOINs in ClickHouse, covering use cases such as star and snowflake schema analytics, large joins exceeding memory, real-time dimension lookups, ASOF joins, and limitations for ultra-low latency queries.