Hi team, is there general rule to improve query performance for queries with lookup function in select and where clauses?

You probably first want to analyze the response metadata to understand where the latency is a) filtering, b) projection/aggregation, c) lookup, d) any custom UDFs. Once we know which part is slow, there are different options to make each part faster.

how about starting from lookup part?

ok

sure