Archives of the TeradataForum

Message Posted: Tue, 12 Jul 2005 @ 18:54:21 GMT

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

Visual Explain needs a Query Capture Database to load the plan. This is mandatory.

If you have a test System of the same DBS release at your disposal, you could try the following workaround to capture the plan on a QCD in your test System. You can setup a QCD on your test system using Control Centre of Visual Explain.

Workaround
==========

(a). Capture the execution plan using the DUMP EXPLAIN modifier example:

          .export file=c:\dump.txt

           DUMP EXPLAIN INTO DUMMYQCD Select col1, col2 from MyDB;

          .export reset

(b). The file will now have statements to capture the execution plan into a QCF database by name DUMMYQCD (Its existance is not neccessary for generating the Dump Explain output)

(c). Replace QCD name "DUMMYQCD" to appropriate QCD name (As the one your test system) in the Dump output and execute these statements on your test system.

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