The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Avatar-Roku
9 months agoNew Contributor III
Reducing Table Size in OS – Need Advice
We're trying to reduce the size of a large table in OS (about 650GB). Our initial idea was to copy the rows to a new table and then rename it, but the insert process takes too long due to the size an...
- 8 months ago
Then you don't really have any restriction in what you do (beyond keeping it around for auditing purposes, particularly if it's related to actual numbers). So you can just have a look around for strategies: https://stackoverflow.com/questions/5296106/how-to-copy-a-huge-table-data-into-another-table-in-sql-server
Avatar-Roku
8 months agoNew Contributor III
It's an audit table located within Application - Database
JackLacava
OneStream Employee
8 months agoThen you don't really have any restriction in what you do (beyond keeping it around for auditing purposes, particularly if it's related to actual numbers). So you can just have a look around for strategies: https://stackoverflow.com/questions/5296106/how-to-copy-a-huge-table-data-into-another-table-in-sql-server
Related Content
- 4 years ago
- 4 years ago
- 3 years ago