Answer Posted / rahul

hi,
primary keys are not mandatory in the teradata,but when
we are specify the pk in column the optimizer creates the
upi in that column. and more over pk composite have no limit
in teradata. the creation of pk is combination of primary
key and not null see the example

create set/multiset table <table name>
(
orderid integer primary key not null,
---
----- etc
);

this creates upi on the orderid column.

if we doesn't mentioned nupi will be created..

thanks

Rahul

In general, how do you optimze any sql in teradata?

559

---

What is collect statistics?

598

---

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

1783

---

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

581

---

Is multi insert ansi standard?

1764

---

---

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

1710

---

How can we check the version of Teradata that we are using currently?

601

---

Can we collect statistics on multiple columns?

574

---

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

649

---

What is dimensional modeling?

599

---

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

598

---

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

554

---

What are the various indexes in teradata?

579

---

What are the primary characteristics of the Teradata.

599

---

How do you verify a complicated sql?

643

---