Use this form to define the tablespace or segment that tables and indexes are stored in. The contents of the form vary depending on where the form is called from.
Note
|
|---|
|
Changes to storage options will not take effect before a table or index is re-created. Changes to some storage parameters require that Microsoft Dynamics AX move or rebuild the selected segment. This can be a time-consuming process. |
Navigating
the form
The following tables provide descriptions for the controls in this form.
SQL Server
options
The following table lists the options that are available when the form is called from a Microsoft Dynamics AX system that is running on Microsoft SQL Server.
Buttons
|
Button |
Description |
|---|---|
|
|
Set storage options for use when you are creating tables. If you select this option, the settings that you specify are used as the default for all tables. |
|
|
Set storage options for a selected table. Selecting this option enables the field, where you can select the table name. |
|
|
Set storage options for use when you are creating indexes. If you select this option, the settings that you specify are used as the default for all indexes. |
|
|
Set storage options for all indexes for a selected table. Selecting this option enables the field, where the table name can be selected. |
|
|
Set storage options for selected indexes for a selected table. Selecting this option enables the and fields where the tables and indexes can be selected. |
|
|
Use the selected value in creating storage. The selected value overrides the database defaults. |
|
|
Save the current storage setup. |
|
|
Restore the original values. |
|
|
View the SQL code in a section at the end of the form. |
|
|
Specifies the table to set storage options for. |
|
|
Specifies the index to set storage options for. |
Fields
|
Field |
Description |
|---|---|
|
|
Specify the segment to use for storing the specified object. Not available unless is selected. |
|
|
Specify the fill factor to use when you are creating the specified object. Not available unless is selected. |
|
|
Create the table using insert row locks. Not available unless is selected. |
Oracle
options
Fields
|
Field |
Description |
|---|---|
|
|
Available tablespaces are displayed here. The default tablespace for tables is AXTAB. The default tablespace for indexes is AXIDX. Changing this parameter results in a move and rebuild of the segment. For a detailed explanation of storage settings, refer to Oracle documentation. |
|
|
Size in kilobytes (KB) of the initial extent in the tablespace. Changing this parameter results in a move and rebuild of the segment. |
|
|
Size in KB of the remaining extents in the tablespace. |
|
|
Total number of extents to be pre-allocated for an object. |
|
|
Total number of extents that can be allocated for an object. |
|
|
The percentage by which each incremental extent is larger than the last extent for the object. |
|
|
Reserves a pre-allocated amount of space for simultaneous update transactions. This option is only applicable for tables. |
|
|
Specifies the maximum amount of simultaneous update transactions at any time. This option is only applicable for tables. |
|
|
Specifies the percentage of free space allocated in each data block for data or index records to expand when updated. A small percentage value is suitable for tables that are rarely updated. |
|
|
Displays the percentage of space that is used. When the amount of data in the data block exceeds this percentage, data is moved to a new data block. This frees the data block for new records. A small percentage value is suitable for tables that are rarely changed. |
|
|
Displays the number of free lists for the segment. |
|
|
Displays the number of free list groups for the segment. Changing this parameter results in a move and rebuild of the segment. |
Oracle
options
The following table lists the options that are available when the form is called from a Microsoft Dynamics AX system that is running on Oracle.
The options apply to partitions, tables, and indexes. When partitioning is enabled, only the values specified for partitioning are used.
The storage parameters displayed depend on the settings for the specified tablespace.
Microsoft Dynamics AX uses the following algorithm to determine which type of tablespace to use.
-
Tablespace specified in the form.
-
Default tablespace for the segment type (only if one item is selected).
-
Default tablespace for the current Oracle user.
The storage parameters that are available depend on whether the tablespace is managed locally, and if managed locally, whether the segment space management is manual or automatic.
Buttons
|
Button |
Description |
|---|---|
|
|
Restore the original values. |
Fields
|
Field |
Description |
|---|---|
|
|
Available tablespaces are shown here. The default tablespace for tables is AXTAB. The default tablespace for indexes is AXIDX. Changing this parameter results in a move and rebuild of the segment. For a detailed explanation of storage settings, refer to your Oracle documentation. |
|
|
Size in KB of the initial extent in the tablespace. Changing this parameter results in a move and rebuild of the segment. |
|
|
Size in KB of the remaining extents in the tablespace. |
|
|
Total number of extents to be pre-allocated for an object. |
|
|
Total number of extents that can be allocated for an object. |
|
|
The percentage by which each incremental extent is larger than the last extent for the object. |
|
|
Reserves a pre-allocated amount of space for simultaneous update transactions. This option is only applicable for tables. |
|
|
Specifies the maximum amount of simultaneous update transactions at any time. This option is only applicable for tables. |
|
|
Specifies the percentage of free space allocated in each data block for data or index records to expand when updated. A small percentage value is suitable for tables that are rarely updated. |
|
|
Displays the percentage of space that is used. When the amount of data in the data block exceeds this percentage, data will be moved to a new data block. This frees the data block for new records. A small percentage value is suitable for tables that are rarely changed. |
|
|
Displays the number of free lists for the segment. |
|
|
Displays the number of free list groups for the segment. Changing this parameter results in a move and rebuild of the segment. |
