Archives of the TeradataForum

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

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

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.

Cheers,

Dave

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

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