Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 13 Jan 2012 @ 11:02:36 GMT

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

Subj:   Re: Referential Integrity in Teradata
From:   Dave Wellman

Hi Mushtak,

I can't speak about RI vis-?-vis other DBMS's (sorry) but I can tell you what I've seen from the Teradata perspective.

Firstly, it is my experience that RI is not used that much in Teradata systems. I think the reasons for this are two fold, (1) RI was only introduced into Teradata from @V2R5 onwards and so for those sites that were using Teradata before that it was a case of "it ain't broke so don't fix it", and (2) even with RI available, most sites seem to do the RI checking as part of their ETL code, so they won't add it into the table definitions as well.

Having said the above, "soft RI" which is one of the available options can help speed up the read processing by avoiding joins ** without ** the overhead of RI checking by the dbms. You obviously still have the option of doing the RI logic within the ETL code. I've used this a couple of times with good effect.



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

  <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: 28 Jun 2020