Archives of the TeradataForum
Message Posted: Wed, 21 May 2003 @ 19:00:24 GMT
Anomy Anom wrote:
Do you mean you submit a
"select timestamp_column from table"
and the result set is not ordered?
Rows are not ordered by Primary Index values in Teradata, so a new row is not appended after the "last" row. So if you select without ORDER BY you'll always end up with an unordered result set. This is different to most other RDBMSes.
Btw, it only looks unordered, rows *are* perfectly ordered by ROWID. You just won't recognize it due to hashing.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|