Creates a table.

Creates a table with 25 columns. The data type of two of the columns is date. For a column of primary keys that contains IDs, the data type is integer. The data type of the other 22 columns is varchar. Also, few varchar columns have indexes.

Creates and loads records.

Creates and loads records to the database based on the value that you provide in the command line argument.

Updates records.

Updates one-fifth of total records or 200,000 records, whichever is lower on indexed and non-indexed columns. The update is based on the WHERE clause on the primary key column. The updates are performed by using 10 parallel java threads.

Selects and deletes records.

Selects and deletes one-fifth of the total records or 200,000 records. The deletes are performed by using 10 parallel java threads.

Creates a table by using the

CREATE TABLE AS SELECT

statement, and then drops the first table.

Drops the first table.

Drops the new table that was created by the

CREATE TABLE AS SELECT

statement.

Monitors the time taken for each operation.