What is archive table?
An archive table is a table that stores older rows from another table. The original table is called an archive-enabled table . Db2 can automatically store rows that are deleted from an archive-enabled table in an associated archive table.
How do I archive a table?
- Step 1: Create an archive table. To keep all your archived records in one table, do this step once.
- Step 2: Create an append query to copy data to the archive table.
- Step 3: Create a delete query to remove data from the original table.
- Step 4: Create a macro to run both append and delete queries.
When is it good to split data into related tables?
Direct link to Nicholas’s post “Here’s a good discussion: http://stackoverflow.co…” Basically a single table is good when data is one-to-one. When you have thousands of rows and columns of data, where the data is one-to-many, multiple tables are better to reduce duplicate data.
When is a single table better than multiple tables?
Basically a single table is good when data is one-to-one. When you have thousands of rows and columns of data, where the data is one-to-many, multiple tables are better to reduce duplicate data. Comment on Nicholas’s post “Here’s a good discussion: http://stackoverflow.co…”
How are data related to a related table?
There is one big thing to realize about these tables: they are describing relational data – as in, they are describing data that relates to each other. Each of these tables describe data related to a particular student, and many of the tables replicate the same data.
Why is data set up in various tables?
Originally it was set up in various tables meaning data is linked with UserIds and outputting via sometimes complicated calls to display and manipulate the data as required. Setting up a new system, it almost makes sense to combine all of these tables into one big table of related content.