🎴 Flashcard Mode
Database Concepts and Teradata Architecture
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Maximum no. of secondry indexes allowed on single table
AnswerClick to flip back
A
32
💡 Explanation:
Teradata allows a maximum of 32 secondary indexes per table. Secondary indexes provide alternative access paths but consume overhead. The limit exists to balance flexibility with system performance. 64, 128, and 256 are not the correct limits.