This tab lists the automatically generated SQL statement.
|
Note:
|
Menu | Description |
---|---|
Copy |
Copy the query to the clipboard. |
Save As |
Save the query to a file. |
View Query in Code Editor |
Copy the query directly to the Code Editor. |
Show the results of executing the generated query.
|
Note:
|
SQL Optimizer supplements Oracle tuning skills for developers. The SQL Optimizer makes observations about a selected SQL statement and the underlying database environment, then recommends several options to improve performance. Users can then view the logic behind the advice, implement the recommendation, apply it to the database, and see the results. The SQL Optimizer module automatically produces all necessary SQL to effect the corresponding change.
|
Note:
|
SQL Navigator executes long-running tasks in separate threads in the background. They lock only the current session. Background execution happens automatically, and means that all the application’s functionality remains available to the user while the task is running in a separate session.
The Task Manager is a display of all active and complete tasks for the current session.
The following background tasks can be managed through the Task Manager:
Background Tasks | More Information |
---|---|
Batch commands on database objects, such as Drop, Compile, Truncate and Extract DDL | Object Menu |
Enable | Constraint Editor |
Execute PL/SQL code | PL/SQL Execution Console |
View Differences | Difference Viewer |
Full expansion of a node in DB Navigator | DB Navigator |
Source Code Search | Database Source Code Search |
Find Objects | Find and Replace |
|
Note:
|
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center