Tag: databases

Tpump

BulKLoad

FastLoad

MultiLoad

All data rows are copied into temporary space

Each data block for a table is read

Each data row is accessed only one

A random set of data blocks for a table is read

When choosing a primary index you should pick a column with a severely limited value set

If distribution is skewed an all-AMP operation will take longer than if all AMPs were evenly utilized

Selecting a NUPI for storing data provides for maximum efficiency and makes the best use of the parallel features of Teradata

The degree of uniqueness is not critical ot efficiency.

Mature optimizer

Industry standard access language(SQL)

Concurrent users

Parallel architecture

Teradata Manager

BTEQ

Teradata SQL Assistant

TDQM

70 GB

50GB

30 GB

80 GB

It is based on the Secondary Index

It is based on the primary key of the table

It is on the partitioning column

It is based on the Primary Index of the table

It is the Primary Key of the table, which guarantees uniqueness

It allows instantaneous dropping of old data and rapid addition of new data

It avoids full table scans without the overhead of a secondary index.

It places all data in a specific range on the same AMP.

creating a report to show a comparison of sales from this week to last week

creating a report show how much credit can be extended to a customer

creating a report that shows the top ten selling items across all stores for one year

updating a checking account to reflect a deposit

70GB

80GB

10GB

30GB