Multiple choice technology databases

Maximum no. of secondry indexes allowed on single table

  1. 64

  2. 32

  3. 128

  4. 256
Reveal answer Fill a bubble to check yourself
B Correct answer
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.

AI explanation

32 is correct for Teradata — a single table can have a maximum of 32 secondary indexes (this is a well-documented Teradata RDBMS limit, distinct from the single Primary Index every table has). The other numbers (64, 128, 256) are plausible round-number distractors but don't match Teradata's documented per-table secondary index limit.

Keep practicing — related questions