|
|
|
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.
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/12/2008 9:19:53 PM
Posts: 469,
Visits: 463
|
|
|
rowkey is the combination of partition# plus the rowid. (just like how rowid is the combination of rowhash and uniqueness value)
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 2 days ago @ 3:54:26 PM
Posts: 225,
Visits: 541
|
|
|
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.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/20/2008 7:20:02 AM
Posts: 9,
Visits: 278
|
|
Can 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.
Regards,
Ansh
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Today @ 7:20:23 AM
Posts: 533,
Visits: 282
|
|
Joe 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 :-)
Dieter
|
|
|
|