Installation Guide > About Optimizing SQL
The Optimize SQL function analyzes the input SQL statement and uses an Artificial Intelligence Engine to produce a group of semantically equivalent versions of the statement, known as SQL alternatives.
Release Notes > Execution Method Options
Note: This topic focuses on information that may be unfamiliar to you. ... It does not include all step and field descriptions. ... Review the following for additional information: ... Maximum rows to be retrieved (records)
User Guide > Troubleshoot Optimization Results
After you optimize the original SQL statement and determine the best alternatives, you may find the performance of the selected statements unsatisfactory in your database environment. ... Make adjustments to the intelligence, optimization, SQL options, or quota setting options if SQL Optimizer has reached any of the quotas.
Installation Guide > Generate Execution Plan Alternatives
Plan Control sessions optimize your SQL statement by generating execution plan alternatives for the statement. ... You can then select an alternative execution plan for your SQL statement and deploy it as a plan guide to improve database performance.
Installation Guide > WFSCAN
Scan a work file. ... A work file scan construct contains a WFSCAN node plus a work file node that is labeled WORKFILE.
Release Notes > Additional Resources
Find DBMS and SQL knowledge, find software downloads, and find answers to your database questions. ... Click here to go to Toad World or follow the instructions below. ... To go to Toad World ... Click Help and select Go to Toad World.
User Guide > Index Setting Options
This topic focuses on information that may be unfamiliar to you. ... It does not include all step and field descriptions. ... To set index settings ... Click . ... Select Optimize SQL | Index Generation | Index Settings.
User Guide > View Schema Information
Note: This topic focuses on information that may be unfamiliar to you. ... It does not include all step and field descriptions. ... To view schema information ... Select the SQL Details tab in the main window.
Installation Guide > Automatically Optimize SQL Statements
Use the Auto Optimize function to perform the optimization and testing processes simultaneously. ... The function optimizes your original SQL statement by generating alternatives and starts testing once SQL Optimizer generates the first alternative.
User Guide > Create Support Bundles
The Support Bundle provides any easy way for you to contact Quest technical support to report a problem or ask a question. ... It includes information about each module of the application and your local computer; and can be used to help troubleshoot problems.
Installation Guide > Create Support Bundles
The Support Bundle provides any easy way for you to contact Quest technical support to report a problem or ask a question. ... It includes information about each module of the application and your local computer; and can be used to help troubleshoot problems.
Release Notes > Register SQL Optimizer
Select Help | Licensing. ... Review the following for additional information: ... Authorization key ... Enter the license key for SQL Optimizer. ... Enter the site message included with the license key.
User Guide > Open Optimizer SQL Sessions
Note: This topic focuses on information that may be unfamiliar to you. ... It does not include all step and field descriptions. ... To open a session ... Select the SQL Details tab in the main window.
User Guide > SIXSCAN
Access and scan with a sparse index. ... A sparse index scan construct contains two nodes: a SIXSCAN node and a sparse index node labeled SPARSE INDEX.
Release Notes > DIXSCAN
DIXSCAN Represents access by XML DOCID index scan.
User Guide > Join the SQL Optimizer Community
The SQL Optimizer for DB2 z/OS Community is available for you to find the latest information about SQL Optimizer. ... By joining the community, you can participate in the beta program, communicate with the development team and other users in the discussion forums, and read blog entries.
User Guide > XIXAND
Denotes operation where DB2 returns intersection of two sorted DOCID lists. ... Output includes only DOCIDs in both lists.
Release Notes > Compare SQL Statements
Use the Compare window to view the SQL text, execution plan, and execution statistics for your original SQL statement and all alternatives SQL Optimizer generated. ... The Compare window consists of the Alternatives window and the Comparison window.
User Guide > FETCH
Represents the retrieval of columns for a row.
Release Notes > Connect to the Database
Note: This topic focuses on information that may be unfamiliar to you. ... It does not include all step and field descriptions. ... Review the following for additional information: ... Select name of the database to which you want to connect.
Installation Guide > UNIONA
Combine rows from multiple tables and retain duplicate rows. ... An UNION ALL construct contains a UNIONA node and at least one subtree. ... Subtrees denote any source query blocks.
Release Notes > Product Licensing
Select Help | Licensing. ... Enter your Authorization key. ... Enter your site message if you have a Production key.
Release Notes > HBJOIN
Use to perform a hybrid join. ... A hybrid join is used only on inner joins. ... The construct contains a single HBJOIN node and two subtrees.
Release Notes > Intelligence Options (Index Generation)
This topic focuses on information that may be unfamiliar to you. ... It does not include all step and field descriptions. ... Select whether to use custom or predefined intelligence levels. ... If you select predefined, the levels range as follows:
User Guide > Execution Plan Options
Note: This topic focuses on information that may be unfamiliar to you. ... It does not include all step and field descriptions. ... Review the following for additional information: ... Specify a table size threshold at which the TABLE ACCESS FULL operation is highlighted in red.
Neue Produktverknüpfung
- Self-Service-Tools
- Knowledge Base
- Benachrichtigungen und Warnmeldungen
- Produkt-Support
- Software-Downloads
- Technische Dokumentationen
- Benutzerforen
- Videoanleitungen
- RSS Feed
- Kontakt
- Technische Support
- Alle anzeigen