1

I've queried our mendix database to get the biggest tables in the database. I see a lot of big index tables for the system$user and system$owner attributes. Is it so that for each system$user attribute on a entity the database creates an index? public.idxstock$stocklevelupdatelinesystem$owner public.idxstock$stocklevelupdatelinesystem$changedby The sysem$user and system$changedby are unnecessary in most of the entities in our application. So I've checked out most of them. I want to deploy this so that these indexes will be removed. But when you delete an attribute, I know that mendix doesn't delete them but renames it with a prefix deleted_[tablename]. That means that these indexes will remain and claiming disk space. Am I right?

asked 2012-01-06

1 answers