Archives of the TeradataForum

Message Posted: Wed, 21 May 2003 @ 19:00:24 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

Dieter

	<Prev	Next>		<<First	<Prev	Next>	Last>>