Setting Table Properties |
You can modify the settings you added when you created a table, and view the table constraints. The following properties may be altered:
Lock Mode: The lock mode of a table identifies the type of lock that DBMaker places on objects when accessing the database. DBMaker supports three levels of lock mode: TABLE, PAGE, and ROW. The default lock mode is the PAGE lock mode. If the lock mode is set to a higher level (such as TABLE), the level of concurrency on database accesses will be lower, but the required lock resources (shared memory) will also be smaller. If the lock mode is set to a lower level (such as ROW), the level of concurrency on database accesses will be higher, but the required lock resources (shared memory) will be larger.
Fill Factor: The Fill Factor specifies the percentage of a page that can be filled before it stops allowing new records to be filled. The lower theFill Factor value, the greater it facilitates the existing records in the page to grow.
Cache / No-cache: The no-cache feature is useful when accessing large tables by table scan. Table scans on large tables can cause frequent disk I/O activity and can consume all available shared memory. This happens during a table scan on a table with a larger number of data pages than the number of page buffers, which causes all page buffers to be exhausted. Once the no-cache option is specified when creating a table, DBMaker only uses one page buffer to cache the data retrieved from a table during a table scan. This prevents the page buffers from being exhausted by one large table scan.
Serial: Resets the serial number for a serial type column in the table
Related topic: