Answer Posted / sri krishna

Teradata automatically Creates the Primary index , if not
specified by the DDl for Table .Some of the Other Types of
indexes are
Secondary Index
Partitioned Primary Index
Join Index


Primary Index :- the PI is the way , Teradata Distributes
the Data , Accesses the Data to/from Amps. By Using the
Primary Index with Value or Range of Values in the Where
Clause of the Query , the operation Becomes a Single AMP/
Few amp aperation instead of all amp operation . the Access
path is
Rowhash of the Pi is known --> Amp of the Column along
with rowid of the Column . (1 Amp Ops)

Results
1. Highly Optimised Query Retrival
2. less Cost per Retrival

Secondary Index / Join Indexes :-

Creates a Secondary Index / Joinindex / Hashindex
Subtable , which maps the Column/s of the SI and the PI
Hash /Join(Frequently used Columns in two tables in this
Case ) , The operations , if using these Indexes are
basically 2 or more amp operation .

Results
1. Quicker Query Retrival time than a full table scan .
2. costs less on the Resources than a FTS
3. the Performance is improved if the JI is used by the
Optimizer

cons --

1. Additional Space Req. for the Subtables
2. need to be droped and recreated for Loads to happen
(Multi Load , FastLoad)ect , which is a real PAIN !!!
3.still be a 2 amp operation when compared to PI Retrival
for a SI.


PPI :-

Partitioned Primary Indexes are Created so as to divide the
table onto partitions based on Range or Values as Required .

the data is first Hashed into Amps , then Stored in amps
based on the Partitions !!! which when Retrived for a
single partition / multiple Partitions , will be a all amps
Scan, but not a Full Table Scan !!!! . this is effective
for Larger Tables partitioned on the Date Specially !!!
there is no extra Overhead on the System (no Spl Tables
Created ect )

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1745

---

Comment whether bottleneck is an error or not.

1163

---

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2423

---

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2172

---

Explain fastload in teradata?

1113

---

What are the scenarios in which full table scans occurs?

1010

---

What is meant by a Parsing Engine?

1191

---

why use references rather than pointers in the public api, particularly for arguments which are modified?

1011

---

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

990

---

What are the different methods ot loading a dimension table? A fact table etc?

1044

---

What's the difference between timestamp (0) and timestamp (6)?

1200

---

How do you set the session mode parameters in bteq?

1110

---

Explain PDE.

1085

---

What are differences between teradata and ansi session modes in teradata?

1176

---

What are the various indexes in teradata?

1052

---