Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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



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