Teradata Forums / Data Warehousing / Teradata / Difference between Secondary Index and Hash Index / Latest PostsInstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 18:45:30 GMT20RE: Difference between Secondary Index and Hash Indexhttp://www.teradata.com/teradataforum/Topic11141-1-1.aspxHi 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.DieterSat, 05 Apr 2008 08:39:38 GMTdnoethDifference between Secondary Index and Hash Indexhttp://www.teradata.com/teradataforum/Topic11141-1-1.aspxCan anyone expain the diff b/w Secondary Index and Hash IndexAlso In which scenario we will go for Hash Index?...Fri, 04 Apr 2008 08:47:46 GMTravindrareddy