Table and index options (form)
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.
Tasks that use this form
Navigating the form
The following tables provide descriptions for the controls in this form.
Fields
Field |
Description |
|---|---|
Enable compression |
Select this check box to enable table data compression, and then select the type of compression: None, Page or Row. Note 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).