Archives of the TeradataForum

Message Posted: Thu, 19 Aug 2004 @ 15:00:13 GMT

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

We "connect" various Oracle databases to Teradata using the Oracle Transparent Gateway for Teradata.

We set up a database link in Oracle that points to the Oracle Gateway server which in turn points to Teradata. We created views in Oracle on top of the Teradata objects we wish to query. These views cannot be joined to Oracle tables without causing performance problems.

From time to time we run into problems when joining these linked views together. If there is not enough filtering in the query, Oracle will try to bring all the Teradata rows across the network and do the joining on the Oracle server. We resolve this by creating a prejoined view in Teradata and one Oracle linked view referencing this.

We have been using the Oracle Transparent Gateway for over five years now and are satisfied with the current performance of our Gateway applications.

Yonina Schuchman
Sr. DBA
Charming Shoppes, Inc.

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