I have a query I want to explain using SQL Optimizer. I am connected to the database I want to explain it in in Toad and hit the optimizer button but when it invokes SQL optimizer it is in another database (which happens to be a production database).
A couple questions:
Do you have the production database connection defined in the Toad Connection Manager?
Was SQL Optimizer already running when you invoked it from Toad, or did Toad launch the application?
Sorry Jeff. I figured out what I was doing wrong. Thanks.
Senior Database Administrator
Staples Promotional Products
7500 W 110th St
Overland Park , KS 66210