Bookmarks are used to mark a Job in the SQL Scanner window to indicate such things as:
You are currently working on a Job.
You have finished reviewing a Job.
You have determined the critical Jobs to be reviewed first.
If the row contains a bookmark, the complete row text is displayed in fuchsia color. You can have multiple bookmarks.
Right-click on a job and select Add/Remove Bookmark.
In the SQL Scanner if the Job is a Collector file, you can open the Collector file in the SQL Collector window to view the SQL statements.
To open the SQL Collector window
Right-click the job that want to open in the Job List pane and select Open in SQL Collector.
In the SQL Scanner if the selected Job is an Inspector file or the selected SQL statement, you can open the Inspector file in the SQL Inspector window to view the statistics and charts.
To open the SQL Inspector and display the statistics
Right-click the job that want to open in the Job List pane and select Open in SQL Inspector.
All the SQL statements can be saved in a text file from the SQL Scanner, the SQL Repository, the SQL Inspector, and the SQL Optimizer windows. These SQL statements can then be imported into Benchmark Factory 4.6 or later.
To create a file to import into Benchmark Factory
Right-click and select Create Benchmark Factory Import File.
Select the specific SQL statements that you want to save.
Enter the filename and select the file location.