You can capture SQL statements from text-based
files.
Procedure
To capture an SQL statement that is in a text-based file:
- In the Data Source Explorer, right-click the database or
subsystem that the SQL statements in a file run against.
- Select . The Capture section
of the workflow assistant for query tuning opens to the Capture
SQL from File page.
- Browse
for the file that contains the statement.
- Specify
the character set and the statement delimiter.
- click Capture. The
content of the file appears in the table in the Captured
Statements section. The content is not parsed, so all
content in the file before the first statement delimiter appears on
one line in the table. All content in the file until the second statement
delimiter appears as the next line in the table, and so on.
- Right-click the statement and select Invoke
Advisors and Tools. The workflow assistant
for query tuning opens to the Run All Single-Query
Advisors and Analysis Tools page
of the Invoke section. The statement appears
in the Query Text field. For help with this
page, click the Help icon (
), or click in a portion
of the page and type F1.