Teradata Database Administration 12 Test

Create another table with the new partition definition, then submit an INSERT SELECT statement to populate the new table.

Create another table with the new partition definition, then extract the data from the NO RANGE and UNKNOWN partitions and import the data into the new table.

Submit an ALTER TABLE statement to add the new partitions, extract the data from the NO RANGE and UNKNOWN partitions, and import the data into the existing table.

Submit an ALTER TABLE statement to add the new partitions, then data from the NO RANGE and UNKNOWN partitions will automatically be checked against the added partitions.

Set permanent space limits for each table that is created.

Specify a limit on spool space for users in their profile.

Use a low number for the Cylinders saved for PERM setting.

Use the DBQL.LogSQL table instead of the DBQL.LogSummary table.

No statistics need to be collected.

Statistics only need to be collected once.

There is less need for frequent statistics collection.

Statistics are automatically collected as a background process.