We have mvs you can use to avoid this https://sql.clickhouse.com/?query=U0VMRUNUIHByb2plY3QsIE1BWChMRU5HVEgodmVyc2lvbikpIEFTIG1heF92ZXJzaW9uX2xlbmd0aApGUk9NIHB

We have mvs you can use to avoid this https://sql.clickhouse.com/?query=U0VMRUNUIHByb2plY3QsIE1BWChMRU5HVEgodmVyc2lvbikpIEFTIG1heF92ZXJzaW9uX2xlbmd0aApGUk9NIHB5cGkucHlwaV9kb3dubG9hZHNfYnlfdmVyc2lvbgpHUk9VUCBCWSBwcm9qZWN0Ck9SREVSIEJZIG1heF92ZXJzaW9uX2xlbmd0aCBERVNDCkxJTUlUIDEwOwo https://sql.clickhouse.com/?query=U0VMRUNUIHByb2plY3QsIE1BWC... takes 0.1s