Creating QCD in one database, for Visual Explain in another?

Tools & Utilities
Fan

Creating QCD in one database, for Visual Explain in another?

I'm writing reports for a data warehouse, and don't have create database or create macro priviledges in it.

I would like to use Visual Explain to help visualize what my queries are doing.

Thought about downloading TD express and creating a (personal, local) database on my desktop machine for storing a QCD for use with Visual Explain. But then- how could I store the execution plans on my desktop for queries against the data warehouse? Can visual explain access both databases at once?

Or, if it is possible to use VE without creating a database or macros, please let me know how...
1 REPLY
Junior Contributor

Re: Creating QCD in one database, for Visual Explain in another?

Hi Yari,
use "DUMP EXPLAIN ..." in your session to DWH, this returns a lot of INSERTs.
You might run those in another session connected to the demo version.

Dieter