|
|
Archives of the TeradataForum
Message Posted: Thu, 10 Nov 2005 @ 15:59:48 GMT
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
| |