Snowflake, Rajiv Gupta, Data Superhero, Searchoptimizationservice, Clustering.
was clustered on O_ORDERDATE it took 3 s and scanned 3 partition out of 2503 total partition and returned 622.9k row. b. When SOS is enabled on O_ORDERDATE it took 47 s and scanned 2624 partition out of 2624 total partition and returned 622.9k row. Query Profile Comparison Without any second