Archives of the TeradataForum

Message Posted: Thu, 11 Aug 2005 @ 17:35:25 GMT

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

Advanced SQL Suggestions:

Set operations, complex case statements, crosstab queries.

Temp tables, volatile tables, derived tables & correlated subqueries.

Alternative implementations of same query. I use a find unmatched rows problem. You can do an outer join, a not exists subquery or a except set operation. You can also do union all vs or's in filter criteria.

Depending on how advanced, you might introduce some performance optimization techniques. You might want to cover explains, but that may be a different class entirely.

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