Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 19 Feb 2002 @ 17:12:34 GMT

  <Prev Next>   <<First <Prev

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


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020