How many types of index are present in teradata?
- 1 Answers
- 1228 Views
- I also Faced
- E-Mail Answers
Answer / krishna
1 )Primary index
a)UPI
b)NUPI
2) Secondary index
a)USI
b)NUSI
3)Partition primary index
a)Range Partition
b)Case partition
4) Hash index
5)Jion index
| Is This Answer Correct ? | 0 Yes | 0 No |
What is teradata? What are some primary characteristics of teradata?
wt r before journal& after journel.....in teradata
can I use “drop” statement in the utility “fload”?
2 Answers Accenture, CTS, NTT Data,
How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
which option is used to restart the fastexport script ?
Why do you get spool space errors? How do trouble-shoot them?
Can any one plz provide the teradata interview questions?
I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata
What is the difference between global temporary tables and volatile temporary tables?
What are the components used in smp and massively parallel processing (mpp) machines?
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
How do you verify a complicated sql?
Teradata 
