InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:53:33 GMT20http://www.teradata.com/teradataforum/Topic11848-9-1.aspxJoe is right.rowhash + uniqeness value -> ROWID (pre-V2R5)partition# + rowhash + uniqeness value -> ROWKEY (V2R5+)But usually everyone is still using the term ROWID instead of ROWKEY :-)DieterWed, 15 Oct 2008 11:34:46 GMTdnoethhttp://www.teradata.com/teradataforum/Topic11848-9-1.aspxCan anybody pls expalin what a rowkey actually is ?Is it the combination of Partition Id+Row Hash + Uniqueness Value or it is just the Row Hash value being given the same name.Wed, 15 Oct 2008 07:24:57 GMTAnshhttp://www.teradata.com/teradataforum/Topic11848-9-1.aspxNo, rowkey is the rowid minus the uniqueness value. In the absence of a partitioned or value-ordered primary index, the rowkey is simply the row hash.Fri, 13 Jun 2008 13:17:01 GMTJim Chapmanhttp://www.teradata.com/teradataforum/Topic11848-9-1.aspxrowkey is the combination of partition# plus the rowid. (just like how rowid is the combination of rowhash and uniqueness value)Fri, 13 Jun 2008 12:36:24 GMTjoedsilvahttp://www.teradata.com/teradataforum/Topic11848-9-1.aspxCould someone explain what a rowkey is? I have been able to find definitons of row hash and row id, but not rowkey.Fri, 13 Jun 2008 11:38:39 GMTjacksprat