Secondary Index in Teradata?...

 Secondary Index:

1. It can be created to improve the performance.

2. Its an optional.

3. It will not do the table full scan...

    Note: primary index will do the table full scan.

4. Secondary index will be stored in Separate subtable and it will required some additional space in AMP...

5. Secondary index can able to create once the table got created.

    Note: Primary index can able to create while creating a table.

6.Secondary index has a limit of 64 columns only.

7.Secondary index can be changed.

8. The below is the syntax for creating a Secondary index.

Create Unique index (Movie_No) on Movie_List;