I have a table with 100 million rows in Synapse. I have a requirement to query on a part of a text column. It takes close to 30 secs to return the results in Synapse, it takes less than 10 secs for the same table in SQL server database.
I need to improve the performance of this table in Synapse. This table is using Round Robin Dristribution and it has Clustered Columnstore Index on it.
3 freelancer chào giá trung bình$188 cho công việc này
Hi, this is a common issue in Synapsis. I've done some improvements in tables in DW related about it. Some issues was related DTUs contracted or bad practices in modeling.