Ability to configure a custom fill factor per index


A common technique to prevent fast fragmentation of indexes (and thus improve performance) is to specify a custom fill factor on a particular index (e.g. 80-99). In AX2012, this could be controlled from within the application (System Administrator module -> Periodic -> Database -> SQL Administr...

Read more...
0 Comments

Read more...
0 Comments

Category: System administration (316)

STATUS DETAILS
Needs Votes

Ability to control statistics sample size


LCS has functionality to update statistics on a table, but it's lacking the possibility to supply a custom sample size or run a full scan. Having more control on the statistics sample size is crucial, especially in situations where a lot of data is loaded at once (e.g. ETL, import of data via i...

Read more...
1 Comments

Read more...
1 Comments

Category: Lifecycle Services (275)

STATUS DETAILS
Needs Votes