Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 05 Aug 2004 @ 21:52:32 GMT


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


Subj:   Re: PMON explain window
 
From:   Frank C. Martinez IV

Two small corrections...

1) The PMon explain does have estimates as of TTU 7.1, but not in the explain itself, right next to it on the display of the SQL in PMon. On the screen, you have the comparison of estimated to actual. Very nice.

2) The actual table names can be displayed under v2r4 by setting a gdo parameter, can't remember which one, which turns off displaying the table id's and turns on seeing the table names in PMon. I looked through my notes to find the name of the parameter, but couldn't find it.


iv


PS: As far a spool file numbers, well, they can't actually give them names, you know? I mean, what would they use, like "James" or "Martha"?



     
  <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