|
|
Archives of the TeradataForum
Message Posted: Tue, 19 Feb 2002 @ 17:12:34 GMT
Subj: | | Re: Row Id needed |
|
From: | | Dieter N�th |
| -- Accessing by ROW_ID in SQL/SPL is not a especially fast (cannot compare at all to the primary index). | |
If you use EXPLAIN you'll see the reason why: It's always using a Full Table Scan - they probably don't want the users to work with ROWID
too much ;-)
| -- this never used to be (and as far as I'm aware it still isn't) documented or supported by NCR. | |
It is officially supported since R4
Dieter
| |