Multiple choice technology databases

Teradata Index wizard used for

  1. compare performance of multiple workloads

  2. recommend secondary indexes for a table

  3. recommend primay indexes for a table

  4. compare primay and secondary indexes for a table
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The Teradata Index Wizard analyzes a query workload to recommend secondary indexes (USIs and NUSIs) that will improve query performance, rather than primary indexes which are defined during table creation.

Keep practicing — related questions