Design dynamic table queries that perform well with incremental refresh by optimizing joins, aggregations, window functions, and data locality.