rowkey

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

rowkey

Rate Topic

Display Mode

Topic Options

Author

Message

jacksprat

Posted 6/13/2008 11:38:39 AM

Forum Newbie

Group: Forum Members
Last Login: 8/8/2008 4:03:25 PM
Posts: 1, Visits: 8

Could someone explain what a rowkey is?
I have been able to find definitons of row hash and row id, but not rowkey.

Post #11848

joedsilva

Posted 6/13/2008 12:36:24 PM

Supreme Being

Group: Forum Members
Last Login: Today @ 12:27:49 AM
Posts: 429, Visits: 407

rowkey is the combination of partition# plus the rowid. (just like how rowid is the combination of rowhash and uniqueness value)

Post #11850

Jim Chapman

Posted 6/13/2008 1:17:01 PM

Supreme Being

Group: Forum Members
Last Login: Yesterday @ 3:14:13 PM
Posts: 217, Visits: 449

No, 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.

Post #11851

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 2:27am