Difference between Secondary Index and Hash Index

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Difference between Secondary Index and Hash...

Rate Topic

Display Mode

Topic Options

Author

Message

ravindrareddy

Posted 4/4/2008 8:47:46 AM

Forum Newbie

Group: Forum Members
Last Login: 6/10/2008 5:26:30 AM
Posts: 9, Visits: 24

Can anyone expain the diff b/w Secondary Index and Hash Index

Also In which scenario we will go for Hash Index?...

Learn And Share...

URS

Ravindra Red

Post #11141

dnoeth

Posted 4/5/2008 8:39:38 AM

Supreme Being

Group: Forum Members
Last Login: Today @ 1:30:56 PM
Posts: 486, Visits: 216

Hi Ravindra,
check the Database Design manual for all the differences/similarities.

Hash Indexes might be more efficient than NUSIs if the number of rows per value is low, because access might be single-AMP access instead of All-AMP.

Instead of HI i usually prefer Single Table Join Indexes, because it's easier to know, what columns are really stored.

Dieter

Post #11155

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 5:40pm