Archives of the TeradataForum

Message Posted: Thu, 19 Dec 2002 @ 08:57:58 GMT

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

Great post!

How about...

1) Ability to run BTEQ in EXPLAIN mode so every SQL operation is automatically preceded by the EXPLAIN modifier with no editing required. This would greatly assist when capturing pre-upgrade optimiser plans for BTEQ scripts written in tombstone style with too many steps. I have frequently seen > 100 steps in a single script written by people that should know better.

2) Name the offending column for a numeric overflow error.

3) Ability to identify spool usage below user level.

Sorry if any of these can already be achieved through means fair or foul.

Can we have more wishes next year please?

Seasons greetings,

Paul Johnson.

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