Home | Previous Page | Next Page   Logging and Log Administration > Logging > Logging and Nonlogging Tables >

Use of Nonlogging Tables

Choose nonlogging tables if users are primarily analyzing the data and updating it infrequently. Back up nonlogging tables to ensure that you can restore them if transactions or the database server should fail. When you use RAW or SCRATCH tables, data consistency is not guaranteed when moving rows from one fragment to another if an error occurs during an update of the fragmentation columns.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]