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...