Nested queries performance

[lveillard]

Hello! These two queries get the same result, a list of the 256 Units in the Unit table, however by adding .id the query becomes 10x slower.

Is this performance drop normal in surrealDB when getting nested data or might it be related to our schema?

[nickchomey]

What does EXPLAIN say? https://surrealdb.com/docs/surrealql/clauses/explain