Archives of the TeradataForum

Message Posted: Thu, 01 May 2003 @ 12:33:56 GMT

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

<-- Anonymously Posted: Thursday, May 01, 2003 08:28 -->

Hi, we are running VERSION 04.01.03.45 RELEASE V2R.04.01.03.18 and have experienced a join index causing a 3610 error.

The index was comprised of outer joins of 3 small, no more than a few thousand row, reference tables.

The query causing the error was not intended to use the join index....simply a select from one of the constituent reference tables.

The JI was using outer joins, and when changed to inner joins the error was not seen. However, changing the JI to use inner joins is not an option for obvious reasons.

Has anyone else ran into this?

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