Hi All,
We have a client, who has a couple tables in their cloud instance of Business Central, which are taking up a majority of their database space. Specifically, they are concerned with the space that the indexes for these tables are taking up.
The two main culprits are the "Value Entry" and "G/L Entry" tables. They do not seem to have any additional keys defined on them apart from the standard BC keys, of which there are many (20 for G/L Entries and 15 for Value).
To take "Value Entry" as an example, they have ~27M records, which takes up 27M KB of space just for the indexes. This is shaking out to around 1KB of DB space to index a single record. Looking at some other clients, it seems more normal for a 0.5 KB being sufficient per record.
At any rate, does anyone have any tips on resolving this issue? It seems you can clean up indexes via SQL Server with Business Central On-Prem, but there does not look like there are any means of doing this with the Cloud application. Any thoughts would be greatly appreciated.
Thanks!
20
Share
Report
All responses (
Answers (
