Archives of the TeradataForum

Message Posted: Tue, 22 Dec 2009 @ 21:18:10 GMT

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

You collect Stat same way you do on a table but instead of Table name you refer to your JI. Try this:

     COLLECT STAT  INDEX (CCCP_KEY) ON LOANS_RETAIL_EXPSR;

I have got the JI working for your view after I added a row ID from the Left Table (,AK.ROWID AS AK_ROW) on your JI. I am not sure if it is the calculated field that was causing the issue. However I can confirm JI is working using /coming through the view and Joins both the Inner and Outer inside the view.

I am in V12.

HTH!

Thanks and happy holidays!

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