Archives of the TeradataForum

Message Posted: Wed, 21 Apr 2004 @ 14:39:54 GMT

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

Martin,

There was a thread on this a few months back that may offer some help:

www.teradataforum.com/teradata/20040213_201241.htm

The only real alternatives seemed to be working with aliasing where possible to reduce the fully qualified size or break one large view into 2 or more separate ones where a main view joins them all together. The latter just requiring significant explain analysis to insure performance doesn't take a hit.

For a different approach, perhaps you could put your case logic into a look-up type table that could be joined to if the resulting where clause could be made smaller than the case statement? If nothing else, this would be much easier to maintain than a view definition if the data ever changes.

Good luck,

Jason

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