Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 12 Jul 2005 @ 15:02:52 GMT


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


Subj:   Teradata Visual Explain without access to QCF
 
From:   Mike Felts

I'm trying to analyze a query and the EXPLAIN is very long (1895 lines, 274 steps). I'd like to utilize Visual Explain to try and get a better handle on the query so I can try and work out a way to increase the performance of the query. However, I don't have access to QCF (my username doesn't have access to select/insert from/to the tables). Is there a way to use Teradata Visual Explain without access to QCF? I've gone through the documentation but can't see a way to do it, but the tool has alot of options, so I wasn't certain if I missed something.

Barring that, what do people do to analyze explain plans other than just digging through the plan (which looks like it could take forever considering the length of the plan)?


Thanks,

Mike



     
  <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: 27 Dec 2016