Or change the layout entirely to clustered columnstore from row store. All databases are datastructures on disk and memory optimized for specific access and wr

Or change the layout entirely to clustered columnstore from row store. All databases are datastructures on disk and memory optimized for specific access and write patterns.