Archives of the TeradataForum
Message Posted: Mon, 10 Jan 2005 @ 19:04:25 GMT
<-- Anonymously Posted: Monday, January 10, 2005 14:03 -->
Will there be any performance degradation if we have PI columns NOT at the beginning of the table definition?.
1 ) Create table t1 ( i date, j int, k int , L date) Primary index ( k)
2) Create table t1 ( k int, i date, j int , L date) Primary index ( k)
Which is more efficient above? Does it matter?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|