Page History
The Query Monitor Signature Mode and Statement Mode views contain two tools that help you with query, schema, and index optimization. The AI Powered Query Optimization and AI Powered Schema & Index Optimization buttons give you the ability to use the power of AI to review and optimize your queries, schema, and index within seconds. In addition, the AI Optimization History tab displays the results of your queries, including the responses from your completed optimization sessions.
| Table of Contents | ||||
|---|---|---|---|---|
|
Enable or disable AI features
...
- Click either the AI Powered Query Optimization or AI Powered Schema & Index Optimization buttons for the first time after the AI features are enabled. SQL DM displays the AI Feature Terms and Conditions dialog box.
- Read the contents of the agreement, scrolling to the bottom as you read. Note that the agreement checkbox and Accept button are disabled until you scroll to the bottom of the content.
- Once you read all of the terms and conditions, check I agree to the Terms and Conditions, and then click Accept to continue.
...
Using AI Powered Query Optimization
Use the AI Powered Query Optimization feature to optimize a single, problematic SQL query to reduce execution time based on your current schema and index structure.
>>>IMAGES
- and select a single query to optimize from the Event Occurrences table. Note that the selection must be an SQL statement as SQL Query Optimization currently does not support batch statements. Select the appropriate query, and then click Accept Selection. The AI Optimization Request Approval dialog appears. Review the provided schema before sending the information to AI, and then click Approve Submission.
- SQL DM then sends the content for optimization and displays the AI Query Optimization Results dialog. It takes a moment for the process to complete, and until then, the AI Optimization Results area is blank. Once complete, the AI Response appears, displaying the Summary, SQL Code, and the Rollback Code so you can go back on the changes if necessary. Use the copy and paste functions to use the displayed code. Click Close when done.
Using AI Powered Schema & Index Optimization
Use the AI Powered Schema & Index Optimization feature to generate optimal index structures for a set of queries (up to five) to minimize cumulative execution time across all queries.
>>>IMAGES
- and select up to five queries from the Event Occurrences table. All queries must be form the same database. Note that your selections must be SQL statements as batch statements are not supported. Click Accept Selection. The AI Schema & Index Optimization: Statement Approval dialog appears. Click Accept Selected Statements to extract the schema. The AI Optimization Request Approval dialog appears. Review the provided schema before sending the information to AI, and then click Approve Submission.
- SQL DM then sends the content for optimization and displays the AI Schema & Index Optimization Results dialog. It takes a moment for the process to complete, and until then, the AI Optimization Results area is blank. Once complete, the AI Response appears, displaying the Summary, SQL Code, and the Rollback Code so you can go back on the changes if necessary. Use the copy and paste functions to use the displayed code. Click Close when done.
...