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

All-AMP

One-AMP

Multi-AMP

Two-AMP

A logon, submittal of work, and logoff

A single sql statement

A logical unit or work

A single sql, statement and the unit of recovery

select count() from emp group by empno having count() >2;

select empno, count() from emp having count() >2;

select empno, count() from emp where count() >2;

select empno, count() from emp group by empno having count() >2;

Query

Attribute

Relation

Record

AVG ( )

SQRT ( )

COUNT ( )

All the Above

Views

Aliases

Sequence

Normalization

100 rows

50 rows

150 rows

5000 rows

Isolation level2

Isolation level3

Isolation level4

Isolation level1

Second

Fifth

Third

None of above

A commit tran is always implied for every transaction.

Unchained mode is the default mode in ASE

The server does not issue the begin tran implicity

The value of @@tranchained is 0

Tinyint

Money

Float

Smallint