Snowflake, Rajiv Gupta, Data Superhero, Searchoptimizationservice, Clustering.
that clustered column perform well in case of time comparison in above case, but it scans 5 times more partition than what SOS service has scanned. Clustering on high cardinality column might result in expensive re-clustering whenever there is any change in data. SOS enabled table also performed