Question: what is difference between primary index and secondary index in teradata?
Answer: A table can contain only one primary index. More often, you will come across scenarios where the table contains other columns, using which the data is frequently accessed. Teradata will perform full table scan for those queries. ... Secondary indexes are an alternate path to access the data.