Archives of the TeradataForum

Message Posted: Thu, 10 Nov 2005 @ 19:41:56 GMT

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

<-- Anonymously Posted: Thursday, November 10, 2005 12:24 -->

From your description it appears likely that it's the INSERT EXPLAIN that's failing, and not the Visual Explain tool itself. Sometimes you can work around that by using DUMP EXPLAIN to create a script, running the script to populate the QCD (both of those outside of the Visual Explain tool), then loading the plan data in Visual Explain. See the manuals for details.

INSERT EXPLAIN becomes a single huge multistatement request - and it seems that request sometimes becomes larger or more complex than the DBMS can handle.

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