Snowflake, Rajiv Gupta, Data Superhero, Searchoptimizationservice, Clustering.
tables. a. When it was clustered on O_ORDERKEY it took 769 ms and scanned 5 partition out of 2575 total partition and returned 1 row. b. When SOS is enabled on O_ORDERKEY it took 2.2 s and scanned 1 partition out of 2624 total partition and returned 1 row. Query Profile Comparison Although we see