Layout choices improve query performance in general, not specific to sql; sql is just a way to compose queries, not different in execution from queries using spark dataframe for example.
If you query a housing info dataset with a specific range of latitudes and longitudes as a filter, running clustering with lat/lon order using z-ordering or hilbert can improve the query perf. This is dataset and predicate dependent, not sql query type dependent (after all, you just run SELECT statements with different clauses)
How does clustering layout choice (linear, z-ordering) impact SQL? Does z-ordering benefit specific types of SQL queries?
Layout choices improve query performance in general, not specific to sql; sql is just a way to compose queries, not different in execution from queries using spark dataframe for example.
If you query a housing info dataset with a specific range of latitudes and longitudes as a filter, running clustering with lat/lon order using z-ordering or hilbert can improve the query perf. This is dataset and predicate dependent, not sql query type dependent (after all, you just run SELECT statements with different clauses)