My table is bigger than 10 TB now. I just want to select distinct filename from table
which should be only a few rows. But it still cost more than 500GB everytime. I tried to create a clustered table but it can’t update dynamically. Is there a way to do that?