Archives of the TeradataForum
Message Posted: Mon, 28 Mar 2005 @ 21:48:21 GMT
| Subj: || || PPI Partition Order |
| From: || || Srikanth Goli |
In case of partitioned primary indexes, are the partitions value ordered or hash ordered? If I have a sales table, and I have a PPI partitioned
on SaleDate, are the partitions ordered by the date value or the hash of the date value? This would help me decide, whether I want to use the
between date1 and dateN or actually spell out the date values so I can use a equality condition (date in (date1, date2, ...etc,.)).