How to create an outlines to another database on Toad
Lisa Hu <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
Dear Toad experts, I need help on how to create an outline from one database to another in toad (not sure if it uses Plan Control in Toad). I am running into a situation that a new SQL runs in 20 secs on Test DB, while 40 mints on Prod. It’s same SQL but data is a little bit different. All parameters, indexes, tables are same on both DBs. Both are 10.2.0.5 on similar hardware. I am trying to export a stored outline on Test , and import to Prod Db (it's a fast fix because users are waiting to migrate SQL to production DB). I heard Toad has tools to copy execution plan from one DB to other. Can anyone instruct me to accomplish this task? Any help will be greatly appreciated. Lisa