This can provide performance improvements because operations on non-transactional temporary tables do not require entries in the rollback log. ![]() Specifies that the temporary table is not affected by either COMMIT or ROLLBACK. Scripting name: TemporaryTable, ExtGlobalTemporaryTable Specifies either temporary table is a global or a local temporary table. Encrypting a table may take time, depending on the size of the table. If no semicolon is present, a period is the field delimiter.Įncrypts the table using the encryption key and algorithm specified at database creation time. Supports the semicolon ( ) as a field delimiter in the location-string. Specifies the dbspace in which the table is to be createdĬreates a table at the specified remote location in addition to a proxy table on the current database that maps to the remote table. If PCTFREE is not set, 200 bytes are reserved in each page. If there is no free space in a table page, every increase in the size of a row on that page requires the row to be split across multiple table pages, causing row fragmentation and possible performance degradation.Įnter an integer between 0 (no free space is to be left on each page) and 100 (high values cause each row to be inserted into a page by itself. Specifies the percentage of free space to reserve for each table page.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |