Our salesorder and salesorderdetail tables are around 34Gb each. We’re investigating using custom tables rather than the built in tables. Our custom tables are less than 1/3 the size but my boss tells me the size reported for the standard tables includes the indexes. The new custom tables haven’t been used and would not include any automatically generated indexes.
I can connect to the instance using SSMS but a standard query to show the index size doesn’t work. Does anyone know how to query the size of a Dataverse table’s indexes?