Archives of the TeradataForum
Message Posted: Thu, 16 Aug 2007 @ 16:21:43 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|