Archives of the TeradataForum
Message Posted: Wed, 26 Apr 2006 @ 11:17:36 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|