![]() Specifies separators to use in parsing a column string into the words to be stored in the index. ![]() Specifies the maximum word length that is permitted. Gives notification messages after n records are successfully added for the index. You can use virtual indexes together with the PLAN function to explore the performance impact of an index, without the often time consuming and resource consuming effects of creating a real index. A virtual index mimics the properties of a real physical index during the evaluation of query plans by the Index Consultant and when the PLAN function is used. The VIRTUAL keyword is primarily for use by the Index Consultant. Scripting name: TemporaryTableOptionsOnCommit Specifies that the rows of a temporary table are deleted on COMMIT. Scripting name: TemporaryTableOptionsNotTransactional For example, NOT TRANSACTIONAL may be useful if procedures that use the temporary table are called repeatedly with no intervening COMMITs or ROLLBACKs. 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 |