User Profile
ggalloway
New Member
Joined 1 year ago
User Widgets
Contributions
ALTER TABLE dbo.tablename REBUILD
If you do many separate inserts or update statements into a table in a Fabric Warehouse you can end up with lots of parquet files and poor performance. I'm not aware there is an auto-optimize feature in Fabric Warehouse yet (and if that's the plan you can potentially close this request depending on how aggressive/quick auto-optimize will be). It would be great to allow the Azure Synapse Analytics syntax ALTER TABLE dbo.tablename REBUILD syntax to work in Fabric which would cause it to do the equivalent of a Spark "optimize" command to rewrite the parquet files to be more efficient and properly sized.243Views3likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.