Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 04 Jan 2011 @ 12:13:32 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Teradata architecture questions?
From:   DWellman


Evene when Teradata accesses a table using the rowhash, it ALWAYS double-checks using the data value.

So, using your example below, assume that your query was:

     Sel *
     From table
     Where column = 1254;

Initially both rows would be found, based on row hash, but then the data value is checked and only the row with the correct data value is used in subsequent processing.

The uniqueness value is not visible to user sql, it is mainly used internally by the dbms so that every single row can be uniquely identified.

Largely forget about it.



Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

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