Wednesday, 22 January 2014

Temporary Tables and the TableType Property [AX 2012]

The following table describes the TableType property.
The default value. These are permanent tables.
A temporary table that exists as an indexed sequential access method (ISAM) file. The ISAM file can exist on either the client tier of the Application Object Server (AOS) tier. The underlying Microsoft SQL Server has no connection to the ISAM file.
The system does allow you join an InMemory table in the X++ SQL syntax. However, joins and other set operations with InMemory tables are usually inefficient.
For more information, see Temporary InMemory Tables.
An InMemory table is the same thing as what was previously called a temporary table in Microsoft Dynamics AX 2009.
A temporary table that resides in the TempDB database of the underlying SQL Server. The nonstandard format of a TempDB table causes the table to be dropped when it is no longer in use by the current method.
Joins and other set operations on TempDB tables can be efficient.
For more information, see Temporary TempDB Tables.

No comments:

Post a Comment