Archives of the TeradataForum

Message Posted: Thu, 16 Aug 2007 @ 16:21:43 GMT

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

Each row in a table contains a rowid (64 bits long). We use to be able to select and compare on it. However, that is not the case anymore. I believe I read somewhere that the DBS Control is used to specify whether or not you can use this column - by default, you cannot use it. Since the developers of Teradata are using it more and more internally, they have discouraged us from using it.

Regardless, if they are truly duplicate rows, hypothetically, does it really matter which one was inserted last?

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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