Installation Guide > SORT
<P>Sort result set in the order specified from the join process or the query.</P> ... <P class=TopicLine> </P>
Installation Guide > 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.
Installation Guide > Review Execution Plans
The execution plan can be displayed in different ways to help you get more detailed information. ... Right-click the plan and select View Plan. ... Select one of the following display options: ... As Tree Plan
Installation Guide > Create User Defined Alternatives
In addition to using SQL Optimizer to generate alternative statements, you can create user defined alternatives. ... You can create user defined alternatives using SQL text from your original SQL statement or from SQL text of an alternative SQL Optimizer generated.
Release Notes > Install or Upgrade SQL Optimizer
Install or Upgrade SQL Optimizer ... To install or upgrade SQL Optimizer ... Run the SQL Optimizer installation program. ... Complete the wizard.
Release Notes > 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.
Release Notes > QB
Auxiliary node that represents a subquery in a particular SQL statement. ... A subquery can be any of the following operations: ... MERGE ... INSERT ... UNION ALL ... Notes: ... The query block node is the root of a subtree and represents the whole subquery.
Installation Guide > UNION
Combine rows from multiple tables and remove duplicate rows. ... A UNION construct contains a UNION node and at least one subtree. ... Each subtree contains a WFSCAN node, a WORKFILE node, a SORT node, and the source query block node.
Installation Guide > About us
We are on a quest to make your information technology work harder for you. ... That is why we build community-driven software solutions that help you spend less time on IT administration and more time on business innovation.
Release Notes > MERGESTMT
This node merges the conditional UPDATE and INSERT operation on a target table or view into one statement.
Installation Guide > SQL 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 whether to set the current degree of intra-partition parallelism.
Release Notes > TBSCAN
Use to read every row in a table. ... A table space scan construct consists of two nodes: a TBSCAN node and some type of table node such as a base table, a materialized query table, a work file, a pipe, or a table function.
Release Notes > IXAND
Represents the intersection of two sorted ROWID lists. ... Output includes only ROWIDs in both lists.
Release Notes > 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.
Installation Guide > MERGE
<P>Merge multiply data streams into a single data stream.</P> ... <P class=TopicLine> </P>
Installation Guide > Review Alternatives
Use the Alternatives pane to review the SQL text and execution plan for the alternatives SQL Optimizer generates. ... You can also review the run-time statistics for your original SQL statement and the alternatives after you execute the statements.
Release Notes > NLJOIN
Use to perform a nested loop join. ... This join is used to join tables and is represented by a NLJOIN node and right and left subtrees. ... The inner table is represented by the right subtree and the outer table by the left subtree.
Release Notes > 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.
Release Notes > STARJOIN
Use to perform a star join. ... Star join allows you to join a dimension column of a fact table to the key column in the corresponding dimension table.
Release Notes > HSSCAN
HSSCAN Use to perform a HASH SCAN.
Installation Guide > View Bind Variables
Note: This topic focuses on information that may be unfamiliar to you. ... It does not include all step and field descriptions. ... To view bind variables ... Select the SQL Details tab in the main window.
Release Notes > Get Execution Plans
Note: This topic focuses on information that may be unfamiliar to you. ... It does not include all step and field descriptions. ... SQL Optimizer automatically retrieves the execution plan when you optimize or test run a SQL statement.
Installation Guide > Animate Execution Plans
You can animate each step in the execution plan in the order SQL Optimizer executes them. ... Right-click the execution plan and select Animate Plan Steps. ... Related Topics ... About Execution Plans
Installation Guide > Intelligence Options
Note: This topic focuses on information that may be unfamiliar to you. ... It does not include all step and field descriptions. ... To set intelligence options ... Click . ... Select Optimize SQL | SQL Rewrite | Intelligence
User Guide > RGLIST
Welcome > SQL Operations > RGLIST ... Use to perform a range-list Scan.
New Product Association
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- RSS Feed
- Contact Us
- Technical Support
- View All