Archives of the TeradataForum
Message Posted: Wed, 26 Apr 2006 @ 11:17:36 GMT
Subj: | | Index Mechanism? |
|
From: | | Sujay Shirish Paranjpe |
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
|