Archives of the TeradataForum

Message Posted: Fri, 28 Apr 2006 @ 10:11:41 GMT

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

I'm not about to diagnose your SQL - if any one was to do that, it would best be the people who wrote it in the first place. However, here is a simple thought that might get you past your problem.

Load the content of the views into a table and use these tables in your select.

You could use volatile tables which don't use perm space (they use spool - just like the views would have). Make sure you choose a decent PI for them.

Since you have loaded the views into volatile table, the final select will have less tables in its join clause and should allow you to work around the problem.

Example:

     Create volatile table t_party_active_customer as (
        Select * from v_party_active_customer
     )
     With data
     Primary index (.....)

Glenn Mc

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