Data Modeling, Data Warehouse, Databricks Sql, Databricks, Data Governance.
performance. ALTER TABLE tpch_obt CLUSTER BY (c_mktsegment); OPTIMIZE tpch_obt; Subsequently querying the table (same statement as before) results in >20x task speed up and >3x wall-clock duration, bringing the latter down to 1.13 seconds. The optimized data layout by liquid clustering effectively