Sunday, April 28, 2013

Teradata Index Types

The following types of indexes exists in teradata:

  • Primary Index
    • Unique Primary Index
    • Non-Unique Primary Index
    • No Primary Index
  • Secondary Index
    • Unique Secondary Index
    • Non-Unique Secondary Index
  • Join Index
    • Single-Table Join Index
    • Multi-Table Join Index
    • Aggregate Join Index
    • Sparse Join Index
  • Hash Index
  • Partitioned Primary Index
    • Single Level Partition
    • Multi Level Partition