Archives of the TeradataForum

Message Posted: Wed, 26 Apr 2006 @ 11:17:36 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I have a question related to Index.

     Case 1:
     Create Table Tab1 (
     Col1 INT,
     Col2 INT
     ) UNIQUE PRIMARY INDEX (Col1)


     Case 2:
     Create Table Tab2 (
     Col1 INT,
     Col2 INT
     ) UNIQUE PRIMARY INDEX (Col1, Col2)

In the first case value of Col1 will be used while inserting and pulling the data from AMPs. But how exactly the Indexing will work in the second case? Is it the case that the combination of Col1 and Col2 will be HASHED and then that hash value is used to insert or pull data from database?

Please help.

Sujay Paranjpe

	<Prev	Next>		<<First	<Prev	Next>	Last>>