Nonstop Database, HiRDB Version 9 UAP Development Guide
![[Contents]](FIGURE/CONTENT.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
(1) SQL optimization specifications
The SQL optimization specifications consist of the following optimization methods:
- SQL optimization specification for a used index
- SQL optimization specification for a join method
- SQL optimization specification for a subquery execution method
(2) SQL optimization options
The SQL optimization options consist of the following optimization methods:
- Forced nest-loop-join
- Making multiple SQL objects
- Increasing the target floatable servers (back-end servers for fetching data)
- Prioritized nest-loop-join
- Increasing the number of floatable server candidates
- Priority of OR multiple index use
- Group processing, ORDER BY processing, and DISTINCT set function processing at the local back-end server
- Suppressing use of AND multiple indexes
- Rapid grouping processing
- Limiting the floatable target servers (back-end servers for fetching data)
- Separating data collecting servers
- Suppressing index use
- Forcing use of multiple indexes
- Suppressing creation of update-SQL work tables
- Deriving high-speed search conditions
- Applying a key condition that includes a scalar operation
- Facility for batch acquisition from functions provided by plug-ins
- Facility for moving search conditions into derived table
(3) SQL extension optimizing options
The SQL extension optimizing options consist of the following optimization methods:
- Application of optimizing mode 2 based on cost
- Hash join, subquery hash execution
- Facility for applying join conditions including value expression
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.