Explain Plan with Toad

xiaoxiao2021-03-06  18

After installing toad8.0, execute a SQL statement, then want to see its execution plan, report error: not find the specified plan table

But UTLXPLAN.SQL has been run in SQLPLUS, and SET Autotrace ON can also display the execution plan.

This is because toad uses your own table to do Plan Table. You need to build the related objects in your toad. The method is Tools-> Server Side Objects Wizard, perform the wizard, generate the related objects.

转载请注明原文地址:https://www.9cbs.com/read-41190.html

New Post(0)