Answer Posted / yuvaevergreen

PPI arranges the rows in a data block using the value that
we mention in ddl. Range processing would be faster.
Basically rowid would not be used instead value would be used.


create table emp
(
emp char(10),
hiredate date
)
upi(emp)
partition by range_n
(hiredate between date '2000-10-10' and date '2010-10-10'
each interval '1' year);

What do you mean by tpt in teradata?

1021

---

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1171

---

Discuss the advantages of using partitioned primary index in a query?

955

---

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

2168

---

What are the primary characteristics of the Teradata.

1160

---

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2868

---

What are the commands to make a new table, change a table and remove a table in teradata?

1132

---

What are some primary characteristics of teradata?

1002

---

Define views in teradata with syntax.

1081

---

What is the meaning of Caching in Teradata?

1141

---

Differentiate database data and data warehouse data?

1121

---

What happens when a node suffers a downfall?

1135

---

how can we analyze the locks ?

2133

---

What is the difference between fastload and multiload? Which one is faster?

1227

---

What are the various indexes in teradata? How to use them?

1018

---