Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: New Years Wish List
 
From:   Paul Johnson

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023