 |
 |
Archives of the TeradataForum
Message Posted: Sun, 20 Aug 2006 @ 15:05:07 GMT
| Subj: | | Re: Doubt regarding non-partitioned UPI |
| |
| From: | | Dieter Noeth |
Chandana Oak wrote:
| | In a partitioned primary index, the rows are stored first by partition and then by row hash. | |
| | Within the partitions, the rows are sorted by row hash. | |
| | If I create a non-partitioned UPI on a table, are the rows sorted according to row hash? | |
Yes, that's the way Teradata stores data since 25+ years. If a table is not partitioned in V2R5+ then there's an implicit partition number of
0.
Dieter
| |
