Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 10 Nov 2005 @ 15:59:48 GMT


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


Subj:   Re: Visual Explain Error
 
From:   Victor Sokovin

  I get snapshot dump on the database whenever I try to run/capture an explain using Visual Explain. It only happens against a table that has a Join Index on it. The Index is not compressed nor the table. I have upgraded to the latest software but still get this error and it tells me not to submit the last request. Has any one faced the same? Any idea on why this tool does not like the JI? Any work around?  


I can't be of any help with this but I thought I should just mention what I heard from some folks who tried to use the tool in the past. They reported that the tool did not like many features. It would also become unstable with complex queries. My understanding is that it can only be useful as a tool for advanced business users who do not possess technical knowledge of the database but are willing to invest some time into tuning of their relatively simple statements.


Regards,

Victor



     
  <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