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.
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.