How do you specify which Explain Plan table Quest SQL Optimizer should use? (47578)

User wants Quest SQL Optimizer to use a specific plan table already existing in the database instead of SQL Optimizer generating it's own default plan table.

RESOLUTION:

In Quest SQL Optimizer 7.3 and above, you can specify which Explain Plan table to use if you already have one created.

1. Click on "Options" at the top right of the screen.
2. In the Options menu, on the left hand side select General | Options.
3. On the right hand side, select "Use the following plan table" then enter the name of the schema and table.
4. Click OK to complete the setting.