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...
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...
STATUS DETAILS
Needs Votes