Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 04 Jun 2007 @ 12:28:21 GMT


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


Subj:   Re: Help on DIAGNOSTIC command
 
From:   Barry Hull

Most of the diagnostic commands are meant to be used by NCR support personnel, so they are not documented in the manuals. There are a few documented in the Target Level Emulation section of the utilties manual regarding setting of costs.

The one I find most useful is one that you can run immediately prior to an explain statement. It shows you the statistics that the optimizer is looking for in trying to solve the query. The format is:

     diagnostic helpstats on for session;
     explain  ;

Hope that helps.

Barry

Barry Hull
Orange Diamond Consulting, LLC



     
  <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