HPlogo ALLBASE/SQL Performance and Monitoring Guidelines: HP 9000 Computer Systems > Chapter 3 Guidelines on Query Design

Modifying the Access Optimization Plan with SETOPT

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

By default, the ALLBASE/SQL optimizer chooses the access plan for queries. You can specify the access plan with the SETOPT statement. For example, you can specify the use of either serial, index, or hash access for a particular statement. See the "SETOPT" section in the ALLBASE/SQL Reference Manual for more information.

Feedback to webmaster