Table and index options (form) [AX 2012]

Updated: July 19, 2011

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Click System administration > Periodic > Database > SQL administration. Click Table and index options.

Use this form to set up Microsoft SQL Server table data compression options, and index data compression, fill factor, pad index, and sort in tempdb options. Before you change any values, we strongly recommend that you review Tune data access settings, which can help you determine when it is appropriate to use this form. The options in this form are not applied to the database unless you apply them in the SQL administration form.

The following tables provide descriptions for the controls in this form.



Enable compression

Select this check box to enable table data compression, and then select the type of compression: None, Page or Row.


To turn off data compression, you must first select Enable compression, click None for the type of compression, and then close the Select table and index options form, and click Apply compression in the SQL administration form.

Enable fill factor

Select this check box to enable fill factor, and then enter a value for fill factor.

Enable pad index

Select this check box to enable pad index. This option is only available if Enable fill factor has been selected. When pad index is enabled, the padding value is set to the fill factor value.

Enable sort in tempdb

Select this check box to enable sort in tempdb.

Fill factor

Enter a value for fill factor, if fill factor has been enabled.

SQL syntax (unlabeled)

The statements that will be executed when a selected value is applied.

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).