|
Answer» There are 5 different indices present in Teradata
1. Primary Index.
a.Unique primary index.
b. NON Unique primary index.
2. Secondary Index.
a. Unique Secondary index.
b. non Unique Secondary index.
3. Partitioned Primary Index.
a. Case partition (EX. age, salary...).
b. range partition ( ex. date).
4. JOIN index.
a. Single table join index.
b. multiple table join index.
c. Sparse Join index ( CONSTRAINT applied on join index in where clause).
5. Hash index. There are 5 different indices present in Teradata
1. Primary Index.
a.Unique primary index.
b. non Unique primary index.
2. Secondary Index.
a. Unique Secondary index.
b. non Unique Secondary index.
3. Partitioned Primary Index.
a. Case partition (ex. age, salary...).
b. range partition ( ex. date).
4. Join index.
a. Single table join index.
b. multiple table join index.
c. Sparse Join index ( constraint applied on join index in where clause).
5. Hash index.
|
