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 is the meaning of Caching in Teradata?

695

---

How many types of joins are there in teradata?

547

---

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

570

---

Explain the term 'tables' related to relational database management system?

598

---

What is the command in bteq to check for session settings ?

636

---

---

Explain the advantages of partitioned primary index in a query?

567

---

What are the main components of teradata system?

585

---

What is the multi-insert?

615

---

How is MLOAD Teradata Server restarted after execution?

653

---

What is the primary index in teradata?

591

---

What are the different table types that are supported by teradata?

541

---

Define views in teradata with syntax.

642

---

When tpump is used instead of multiload?

631

---

Explain fallback in teradata?

610

---

what is object level locking ? where do appear this type of locking ?

3117

---