Different types of Indexes in Teradata

Database
Enthusiast

Different types of Indexes in Teradata

Hello, Looking for the various types of Indexes that are available in Teradata 13, what's the equivalent of Oracle BTree and Bitmap Indexes in Teradata?

Thanks for your help with this.

3 REPLIES
Enthusiast

Re: Different types of Indexes in Teradata

Teradata has many indexes such as Primary indexes(unqiue , non unique), Secondary indexes(unqiue , non unique), join indexes, hash indexes,sparse indexes..

rows of tables and indexes are distributed to the AMPs using different methods of row allocation. It is MPP architecture. 

In Oracle in a b-tree, you walk the branches until you get to the node that has the data you want to use. No amps.

Bit map indexes in oracle, is used for low predicates. However, I see that making too many indexes for a system creates havoc. Indexes are created only if there is a need to suit the system performance.

Enthusiast

Re: Different types of Indexes in Teradata

Thanks again Raja for your response... will try to go thru the concepts that you are talking about.

Re: Different types of Indexes in Teradata

very useful information. Great work guys and keep it up.